| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menue
Hi Friends, Can we build a Menu on userForm just like as in Visual Basic? Thanks Syed Haider Ali -- Syed Haider Ali ------------------------------------------------------------------------ Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994 View this thread: http://www.excelforum.com/showthread...hreadid=401782 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Menue
No, Userforms do not support menus.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Syed Haider Ali" <Syed.Haider.Ali.1uu86b_1125842703.7522@excelfor um-nospam.com wrote in message news:Syed.Haider.Ali.1uu86b_1125842703.7522@excelf orum-nospam.com... Hi Friends, Can we build a Menu on userForm just like as in Visual Basic? Thanks Syed Haider Ali -- Syed Haider Ali ------------------------------------------------------------------------ Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994 View this thread: http://www.excelforum.com/showthread...hreadid=401782 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Menue
Syed,
You can design a userform to look like a menu. Put a command button for each selection and one for exit (to close the form) e.g. COMMANDBTN ACTION Input data opens an input userform. Edit data opens an edit userform. Print runs the print macro. Search opens a search userform so that you can input your search criteria. Etc. Exit runs the close "Menu" or close Excel macro. You'll have to position it so that it's behind any other userforms you open. Not a proper menu, but it may do what you want. Henry "Chip Pearson" wrote in message ... No, Userforms do not support menus. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Syed Haider Ali" <Syed.Haider.Ali.1uu86b_1125842703.7522@excelfor um-nospam.com wrote in message news:Syed.Haider.Ali.1uu86b_1125842703.7522@excelf orum-nospam.com... Hi Friends, Can we build a Menu on userForm just like as in Visual Basic? Thanks Syed Haider Ali -- Syed Haider Ali ------------------------------------------------------------------------ Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994 View this thread: http://www.excelforum.com/showthread...hreadid=401782 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup help menue is wrong ???? | Excel Worksheet Functions | |||
| drop down menue and autofills | Excel Discussion (Misc queries) | |||
| vb drop down menue | Excel Discussion (Misc queries) | |||
| How do I set up XML on Data menue? | Excel Discussion (Misc queries) | |||
| The Draw Menue "bracket" | Excel Discussion (Misc queries) | |||
![Syed Haider Ali[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
