I want user form to display when opening a work book
 

I would like to create a form that would be visible and remain open by
default every time I open my work book. Amongst other controls, I want a
combo box from where I can choose another work sheet and a command button to
open the sheet I selected. Can anybody explain to me how this can be achieved
please.
Many thanks
JM

I want user form to display when opening a work book
 

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp

Part II
http://msdn.microsoft.com/library/en...rFormsPartII.a

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JohannM" wrote in message
...
I would like to create a form that would be visible and remain open by
default every time I open my work book. Amongst other controls, I want a
combo box from where I can choose another work sheet and a command button
to
open the sheet I selected. Can anybody explain to me how this can be
achieved
please.
Many thanks
JM