I want user form to display when opening a work book

[Guest]

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

 

[Bob Phillips]

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-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp

Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.a

--
HTH

Bob Phillips

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