Menue

Hi Friends,

Can we build a Menu on userForm just like as in Visual Basic?


Thanks

Syed Haider Ali

No, Userforms do not support menus.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Syed Haider Ali"
<[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

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" <[email protected]> wrote in message
news:[email protected]...
> No, Userforms do not support menus.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Syed Haider Ali"
> <[email protected]> wrote in
> message
> news:[email protected]...
>>
>> 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
>>
>
>