Hi
 

Hi

I have a user form with has a text box and a command button
I use the text box to show a cash amount from two different works
sheets

then you click the button to bring up a 2nd userform which ask 3
options eg return to main page etc but i can not seem to close the
first userform it just stay there.

Its late and i have been working for sometime what am i missing?

He is my code

Private Sub CommandButton1_Click()

userform2.show

end sub

Thanks


--
raw
------------------------------------------------------------------------
raw's Profile: http://www.excelforum.com/member.php...o&userid=28312
View this thread: http://www.excelforum.com/showthread...hreadid=479308

Hi
 

maybe...

Private Sub CommandButton1_Click()
me.hide
userform2.show
me.show
end sub

or

Private Sub CommandButton1_Click()
me.hide
userform2.show
unload me
end sub

raw wrote:

Hi

I have a user form with has a text box and a command button
I use the text box to show a cash amount from two different works
sheets

then you click the button to bring up a 2nd userform which ask 3
options eg return to main page etc but i can not seem to close the
first userform it just stay there.

Its late and i have been working for sometime what am i missing?

He is my code

Private Sub CommandButton1_Click()

userform2.show

end sub

Thanks

--
raw
------------------------------------------------------------------------
raw's Profile: http://www.excelforum.com/member.php...o&userid=28312
View this thread: http://www.excelforum.com/showthread...hreadid=479308

--

Dave Peterson