userform

[dantb]

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]

use

Unload FormName

[dantb]

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

[Dave Hawley]

Hi dantb

You may want to use

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