MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Menu Creation

  Asked By: Francisca    Date: Oct 21    Category: MS Office    Views: 1292

Can someone tell me whether one can create complete menus in excel using
excel VBA just like switchboard in MS Access. My question is that by
placing command buttons on the userform in the parent workbook I should
be able to open any workbook of my choice and after completing the
process when I close that workbook my parent form should show up.



2 Answers Found

Answer #1    Answered By: Devlan Jones     Answered On: Oct 21

That is what would normally happen provided you do not close  the userform  or
the workbook  it belongs to. the form  will still be open  in the background
when the extra workbook is opened and when that workbook is closed the focus
will return to the form.

Answer #2    Answered By: Heru Chalthoum     Answered On: Oct 21

Thank you for your valuable information I think I got the logic.

Didn't find what you were looking for? Find more on Menu Creation Or get search suggestion and latest updates.