Starting Dialog Box using Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top