Oprning a User Form
 

i have a worksheet with a bucnch of command buttons that lead to different
dbs. each of these buttons is supposed to open a form for its particular db.
problem is they do not open the forms.

is there an easy to use macro i can assign to these buttons or some code i
can add to each of these that will open the forms?

the first form is in the "Forms" folder and is named UserForm1. the button
that leads to the form is on "Sheet1" and is named "Button3".

Oprning a User Form
 

Opening a form is simple with

Userform1.Show

but what is the forms folder?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cxlough41" wrote in message
...
i have a worksheet with a bucnch of command buttons that lead to different
dbs. each of these buttons is supposed to open a form for its particular
db.
problem is they do not open the forms.

is there an easy to use macro i can assign to these buttons or some code i
can add to each of these that will open the forms?

the first form is in the "Forms" folder and is named UserForm1. the
button
that leads to the form is on "Sheet1" and is named "Button3".

Oprning a User Form
 

Just the location of the folder in the VBA Project frame nothing that i have
changed. I just added that remark because i have tried the simple line of
code but it does not seem to work???

i have no idea where i'm going wrong.

"Bob Phillips" wrote:

Opening a form is simple with

Userform1.Show

but what is the forms folder?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cxlough41" wrote in message
...
i have a worksheet with a bucnch of command buttons that lead to different
dbs. each of these buttons is supposed to open a form for its particular
db.
problem is they do not open the forms.

is there an easy to use macro i can assign to these buttons or some code i
can add to each of these that will open the forms?

the first form is in the "Forms" folder and is named UserForm1. the
button
that leads to the form is on "Sheet1" and is named "Button3".