How can I popup instructions using VBA?

[Guest]

I'd like to create a popup screen describing how to use my worksheet. Ideally
it would be in VBA

The alternative is to create a sheet with the instructions on but this would
be less fun.

I am using Excel 2003 and my knowledge of VBA is limited.

 

[Guest]

The simplest way is to use MsgBox. Put this code into ThisWorkbook module and
every time the file is opened your message appears:

Private Sub Workbook_Open()
MsgBox "How to use this workbook...."
End Sub

 

[Incidental]

Hi Legendash

Another option would be to add a userform to the workbook that you can
call from a keyboard shortcut, this would have the benefit of allowing
you to add images and formatting to your popup and it can be called at
anytime if your workbook requires alot of instructions.

Open VBE (Alt + F11)
add a userform and a module to your project.

on your userform you can add whatever you want the user to see when
they access it

in the module add the code below

Sub LoadPopUP()
UserForm1.Show vbModal 'if you changed the name of your userform also
change it in here
End Sub

Then from the main excel application window select the Macro's option
under the "Tools" menu (Alt + F8) you should see LoadPopUp in the left
textbox highlight it if it is not already and click the "Options"
button from here you can assign a keyboard shortcut to run the macro
and show the userform.

Just another option for you

S

 

[Guest]

Ah, brilliant, thanks a lot.