Starting Dialog Box using Macro


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
 
Ad

Advertisements

G

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top