Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking a userform to the toolbar

Status
Not open for further replies.

jakesups

IS-IT--Management
May 6, 2003
18
0
0
US
Help! I'm trying to add my new userform from MS Project 2000 to the toolbar. I made a simple VBA form, but can only execute it from the editor. I want to make it so that users of the project can execute the form themselves from within the project file.
This sounds like such an easy task, but I'm not getting anywhere. It's my first VBA project, so I'm getting there, just need a little help.

Here's what I've tried, in the project app, I've tried adding to the toolbar, click on customize, click on commands, click on forms, and try to find my form. It is never in the list to choose from. I'm not sure if I have to move it over somehow from the development side or just "publish" it or something.
I've also looked in the ORGANIZER from project, and again my USERFORM is not there.

What can I do?
Thanks, Jake
 
You need to assign a macro to the button on the toolbar to open the form. At its simplest this will be (depending on the name of your form) :-
'------------------------
Sub RunForm()
MyUserFormName.Show
Unload MyUserFormName
End Sub
'------------------------


Regards
BrianB
** Let us know if you get something that works !
================================
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top