Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
USERFORM and MENU
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
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
USERFORM and MENU
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/...astersLink.htm /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ "CHANON" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
USERFORM and MENU
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 pulldown menu such as File, Edit, Tool, etc. Please anyone let me know. Thank you . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
USERFORM and MENU
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
pull down menu on userform | Excel Programming |