USERFORM and MENU

C

CHANON

I would like to know that USERFORM in VAB can add pulldown menu such as File, Edit, Tool, etc. Please anyone let me know. Thank you
 
C

Colo

Hi CHANON,
How about add Microsoft Toolbar Control from right click the toolbox?
But it is not like a Menubar. I have made a form with menubar as a
com-add-in but to do that, I think need VB or MsOffice proffesional.


--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/colo/CellMastersLink.htm
mailto:[email protected]

/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


CHANON said:
I would like to know that USERFORM in VAB can add pulldown menu such as
Click to expand...
File, Edit, Tool, etc. Please anyone let me know. Thank you
 
P

Patrick Molloy

Since a userform is part of the Excel app, the thinking
is that you don't need a userform menu. Why, because you
already have TOTAL control over excel's menus.

However, you can use a workaround. Ass a Combo box with
the correct labels in the list then process the On click
event....

Option ExplicitPrivate Sub cbMyMenu_Change()
Run cbMyMenu.Value
cbMyMenu.ListIndex = 0
End Sub
Private Sub UserForm_Initialize()
cbMyMenu.RowSource = "sheet2!MyMenu"
cbMyMenu.ListIndex = 0
End Sub


The form's initalise method reads the menu list from a
named range on my worksheet - make it easy to edit - and
sets the first item (zero based) in the list. The range
is two columns. The first column is the menu item and the
second is the name of the procedure to be run.

the combobox is set to two columns, the second is hidden
and the bound column is set to two also.

Each time an item is selected, the change event fires,
the change event code "runs" the value of the
combo....since this is the proc name, it runs the
required code.

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
I would like to know that USERFORM in VAB can add
Click to expand...
pulldown menu such as File, Edit, Tool, etc. Please
anyone let me know. Thank you
 
T

Tom Ogilvy

You have received some suggested workarounds, but to answer your specific
question, there is no direct support for it as there is in VB forms.

--
Regards,
Tom Ogilvy

CHANON said:
I would like to know that USERFORM in VAB can add pulldown menu such as
Click to expand...
File, Edit, Tool, etc. Please anyone let me know. Thank you
 
Top