Dialog box and opening an excel file

  • Thread starter Thread starter jks
  • Start date Start date
J

jks

Hi,

Im far from an expert user, so il need someones expertise in thi
matter. I suspect its rather easy to solve.

Ive created a dialog box in an excel file. The box contains certai
buttons with simple macros so i can navigate throgh the document.
want to have the dialog box open automaticly when i open the file. Ho
do I do this ???

Please help me!

/JS
Denmar
 
Hi
one way: you can create a macro name 'Auto_Open()'. This will be
invoked automatically then opening your workbook. Insert your code to
activate your dialog box in this procedure

Frank
 
Thx a lot Frank,

Ive tried to figure out the code for opening a dialog and I cant find
it.

Can u help me once again with this matter ?

/JS
Denmark
 
JS;

You can load the Userform as follows.
In the VBA Editor doubleclick ThisWorkbook.
In the module window, click the 1st dropdownbutton (General) and choose
Workbook.

A new module occurs where you have to insert just one line of code !!
At the end it looks like this.

Private Sub Workbook_Open()
UserForm1.show
End sub

Mark.

More Excel ? www.rosenkrantz.nl or (e-mail address removed)
 
Back
Top