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.