Hi Excel gurus,

I want to create a userform which have a menubar like Master and Data.

If the user clicks the Master, then it should show a dropdown list under it like Master1, Master2, Master3, etc., and same as if the user clicks the Data, then it should show a dropdown list under it like Data1, Data2, Data3, etc.

If the user clicks Master1, then a new userform will be opened and he inputs the required fields in the userform and clicks the save button, the datas entered in the field will be saved in the worksheet and the userform closes or clears the data entered so that he can enter new datas in Master1 userform.

Is it possible, If so please help me.



Expecting your reply at the earliest, Thanks in Advance.

Look at this forum link ( in French ):

https://www.developpez.net/forums/d7...ubar-userform/

Go to GOOGLE and search for TRANSLATE. You can use their universal translator to
convert the macro/s text.

Thank you for the link, I'll try to figure out what is there and try to build it for my own.

Will contact if I am not able to proceed further.

Thanks again.

I created a menubar by using the codes given in the below mentioned website.

http://web.archive.org/web/201204272...MenuMaker.html

Thanks all.