Can a user form be opened from a macro??

  • Thread starter Thread starter mike703
  • Start date Start date
M

mike703

Hi All,

I have a macro that will format project files based on their projec
number. in order to record the prject number. I have created a form fo
the user to enter the project number. My problem is entering a comman
line to open the form once the user selects which type of project fil
is to be formatted (a popup window first displays in the macro).
would like for the user form to popup if the correct button is clicke
on the original popup window. How?
 
Userform1.Show

or do you mean something else?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

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

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Automatically Send a notification email once a record is added 0
Access 2007 newbie with Form Issues 1
Access 2003 Access Error Form Name 0
Restrict Use of a macro 3
How to get a file from a web page 1
Creating Serial Numbers for a form 1
macro popup box 1

Back
Top