UserForm Viewing
 

I am new to userforms. I userstand how to set them up now, but can't figure
out how to make them visible.

I have a piece of code from my manual:

Sub ShowForm
UserForm1.Show
End Sub

But I have no idea where this code is suppose to go.

Any help would be greatly appreciated.
Regards,
Diane

UserForm Viewing
 

Hi Diane

you need to decide when you want the userform to appear -

the code you have goes in a normal code module - in the VBE window - insert
/ module from the menu and copy & paste the sub showform code in there -
you can then access this code from tools / macro / macros ... showform and
run

or from a toolbar button (view /toolbars / customise .. .under the commands
tab on the left hand side, find macros, drag the smiley face button to your
toolbar, right mouse click on it and choose assign macro - choose the
showfrom macro (after you've put it into a module as above) - close the
customise box and click on the smiley face button to display the userform.

these are only two of a number of different ways to display the userform -
so if neither of these are the way you really want to go, please let us know
when / how you'ld like the form to appear and we'll see what other options
we can come up with.

Cheers
JulieD


"Diane Alsing" wrote in message
...
I am new to userforms. I userstand how to set them up now, but can't
figure
out how to make them visible.

I have a piece of code from my manual:

Sub ShowForm
UserForm1.Show
End Sub

But I have no idea where this code is suppose to go.

Any help would be greatly appreciated.
Regards,
Diane

UserForm Viewing
 

Yeah - I was doing that but did not realize I had to RUN the macro to display
the form - duh! Thanks for opening my eyes!

"JulieD" wrote:

Hi Diane

you need to decide when you want the userform to appear -

the code you have goes in a normal code module - in the VBE window - insert
/ module from the menu and copy & paste the sub showform code in there -
you can then access this code from tools / macro / macros ... showform and
run

or from a toolbar button (view /toolbars / customise .. .under the commands
tab on the left hand side, find macros, drag the smiley face button to your
toolbar, right mouse click on it and choose assign macro - choose the
showfrom macro (after you've put it into a module as above) - close the
customise box and click on the smiley face button to display the userform.

these are only two of a number of different ways to display the userform -
so if neither of these are the way you really want to go, please let us know
when / how you'ld like the form to appear and we'll see what other options
we can come up with.

Cheers
JulieD


"Diane Alsing" wrote in message
...
I am new to userforms. I userstand how to set them up now, but can't
figure
out how to make them visible.

I have a piece of code from my manual:

Sub ShowForm
UserForm1.Show
End Sub

But I have no idea where this code is suppose to go.

Any help would be greatly appreciated.
Regards,
Diane

UserForm Viewing
 

glad its solved and thanks for the feedback

"Diane Alsing" wrote in message
...
Yeah - I was doing that but did not realize I had to RUN the macro to
display
the form - duh! Thanks for opening my eyes!

"JulieD" wrote:

Hi Diane

you need to decide when you want the userform to appear -

the code you have goes in a normal code module - in the VBE window -
insert
/ module from the menu and copy & paste the sub showform code in there -
you can then access this code from tools / macro / macros ... showform
and
run

or from a toolbar button (view /toolbars / customise .. .under the
commands
tab on the left hand side, find macros, drag the smiley face button to
your
toolbar, right mouse click on it and choose assign macro - choose the
showfrom macro (after you've put it into a module as above) - close the
customise box and click on the smiley face button to display the
userform.

these are only two of a number of different ways to display the
userform -
so if neither of these are the way you really want to go, please let us
know
when / how you'ld like the form to appear and we'll see what other
options
we can come up with.

Cheers
JulieD


"Diane Alsing" wrote in message
...
I am new to userforms. I userstand how to set them up now, but can't
figure
out how to make them visible.

I have a piece of code from my manual:

Sub ShowForm
UserForm1.Show
End Sub

But I have no idea where this code is suppose to go.

Any help would be greatly appreciated.
Regards,
Diane