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