EXCEL Dialog Box

[Guest_imported]

I'm currently writing a small bugeting program for Excel. I wish to add a macro to a dialog box, However I don't know how to set-up in the dialog box in a presentable manner. The macro will run a help info dialog box with information and then a cancel or Ok button.

I can record and assign the macros, however, I can't set-up the dialog box. The dialog box should look like standard Excel dialog boxes. (I'm running Excel 2000, I know excel fairly well, however I don't use Visual basic)

Please help.

Thanks,

Darren Greenan

 

[dsi]

Go to the VB Editor and add a form. Put all of controls on it. Then, to assign a custom button a macro, create a subroutine to show the form:

Sub ShowHelpForm()
    frmHelp.Show
End Sub

Then, on the button commands:

Sub cmdOK_Click()
    Unload Me
End Sub