userform

dantb · Mar 29th, 2002, 06:01 PM

Hi all. What I have is a userform that has a cmd button going to anouther userform. The other userform opens well, but what I would like is when the new userform opens, the one I was just in closes. I tried the ( End ) comand but it closes both forms out. Is there anouther way ?

daleyman · Mar 29th, 2002, 06:15 PM

use

Unload FormName

dantb · Mar 29th, 2002, 06:17 PM

Thanks Dale, been racking my head on that one, beginer here but learning. Thx Again Dan

Dave Hawley · Mar 29th, 2002, 06:24 PM

Hi dantb

You may want to use

Useform1.Hide if you wish for the UserForm Contols to retain all their Values.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 29th, 2002, 06:01 PM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Hi all. What I have is a userform that has a cmd button going to anouther userform. The other userform opens well, but what I would like is when the new userform opens, the one I was just in closes. I tried the ( End ) comand but it closes both forms out. Is there anouther way ?

Mar 29th, 2002, 06:15 PM	#2
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	use Unload FormName

Mar 29th, 2002, 06:17 PM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Thanks Dale, been racking my head on that one, beginer here but learning. Thx Again Dan

Mar 29th, 2002, 06:24 PM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi dantb You may want to use Useform1.Hide if you wish for the UserForm Contols to retain all their Values.