Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|