Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down Menu (non Data Validation type)
Hello all
I have read the posts regarding how to add a drop down menu to a cell in Excel. However, they all refer to the "data validation" type of list answer I am more interested along the lines of adding a true menu to a cell like you would add a menu to the Excel Worksheet Menu Bar (where File, Help, etc. are located), but again putting it inside of a cell (using a control?).. Basically, I have added a menu to the Worksheet Menu Bar, but now I want to MOVE it to a "cell" on the worksheet... What control would I use to do that? Again, was not looking for the "data validation" answer, was looking more for a control/programming answer like I originally did when I added a new menu to the Worksheet Menu Bar Thank you very much in advance blc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down Menu (non Data Validation type)
I forgot to add my code the first time... Here is the code I use to add a new custom menu to the Worksheet Menu Bar
Dim objEnterProjectInfo As CommandBarButto Dim objNewMenu As CommandBarPopu Dim objHelpMenu As CommandBarContro ' Some code omitte 'Find the Help Men Set objHelpMenu = Application.CommandBars(1).FindControl(ID:=30010 If (objHelpMenu Is Nothing) The Set objNewMenu = Application.CommandBars(1).Controls.Add(Type:=msoC ontrolPopup, temporary:=True objNewMenu.Caption = "Some Text Els 'Add the menu before the Help men Set objNewMenu = Application.CommandBars(1).Controls.Add(Type:=msoC ontrolPopup, befo=objHelpMenu.Index, temporary:=True objNewMenu.Caption = "Some Text End I ' First *Menu* ite Set objEnterProjectInfo = objNewMenu.Controls.Add(Type:=msoControlButton With objEnterProjectInf .Caption = "Open Project... .FaceId = 16 .OnAction = "RSMA.LoadProjectInfo End Wit Thanks again bl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Drop Down Menu Width | Excel Discussion (Misc queries) | |||
Data-Validation -List - Pick from a drop down menu | Excel Discussion (Misc queries) | |||
The drop down menu of my validation list needs to display more. | Excel Discussion (Misc queries) | |||
Validation- Drop Down menu size | Excel Discussion (Misc queries) | |||
How do I set up a drop down menu for a validation list? | Excel Worksheet Functions |