How do I show a "User Form" created in VBA

L

LCO

I have created a User Form in Prj2k2 using the VBA
environment and can't seem to create a macro to show the
form from the project toolbar.

How can I get my form to show without running it from
within the VBA environment?
 
J

Jan De Messemaeker

Hi,
IMHO you can't
Moreover I fail to see the interst of showing a form and not handling the
data
HTH
 
M

Mark Durrenberger

Write a macro
then call the form from the macro
Tie the macro to a button on a toolbar...

Sub Macro1
myform.show (vbmodal)
endsub

--
_________________________________________________________
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
________________________________________________________

The nicest thing about NOT planning is that failure
comes as a complete surprise and is not preceded by
a period of worry and depression.

- Sir John Harvey-Jones
 
L

LCO

Thanks for the reply... I figured it out right after I
posted, dope! some times you just have to step back for a
moment.
 
L

LCO

my interest is this... I need to create a CRT of my own to
handle additional cost data that changes rates over time..
so I modeled the "Resource Information Dialogs CRT" in my
own user form to handle updating custom costs and number
fields so that the client has a nice interface to work
with.

you show the form like this

Sub OpenMyCRT()
' Show Custom Cost Info Form
' Macro Recorded Mon 04-09-20 by Lenford Oleman.

TrexCostAddinsForm.Show

End Sub
and thank you for the reply.
LCO
 

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