Starting Dialog Box using Macro

[Guest]

I am attempting to run a VB script which is a dialog box which gets data, then inserts it into a sheet. I have attempted to write a "macro" to start the dialog, but it does nothing. I have tried several methods, the last one is below

Sub EnterEmployment(

' EnterEmployment Macr
' Macro recorded 3/23/200

' Keyboard Shortcut: Ctrl+Shift+

Application.Run ("Employment"
End Su

The userform is named "Employment" and will run if started in the VB editor using F5

Thanks

John H W

 

[gitcypher]

DialogSheets("Employment").show

to hide...
DialogSheets("Employment").hid

 

[gitcypher]

You're using a user form created in the visual baic editor (whereas
can't help you). What I gave you is for a dialog sheet. It's created b
right clicking any sheet, then going to *insert* and selecting *M
Excel 5.0 Dialg *.

If you have any questions on how to manipulate those forms, I'm here.

-gitcyphe

 

[Steve Garman]

Have you tried:

Sub EnterEmployment()
Employment.Show
End Sub

 

[Guest]

I found that that worked this morning

Thanks for the reply

John H