Switching Userform Error

**amotto11** · 03-06-2013, 05:00 PM

Hi All,

I have one userform called "Initial" and one userform called "Data Entry". The "Initial" userform is the initial userform that the user sees upon opening the workbook. It contains two buttons (Data Entry and Reports). Clicking Data entry will show the "Data Entry" userform, this works as it should. This userform has no close button, only the X at the top right of the screen. therefore i have added this code to my userform:

Please Login or Register  to view this content.

This will work all and good to close the "Data Entry" userform and open the "Initial" userform. Basically creating a switch between the two userforms, i only want the user to go between the two userforms. My problem comes when i then click Data Entry on the "Initial" userform. It shows the "Data Entry" userform but on my other monitor and my userform does not populate my combo boxes or anything, also i am no longer able to close out of the "Data Entry" userform with the X. It is almost as though it is not initializing it or something. Any help on this is greatly appretiated. Thanks.

**JosephP** · 03-06-2013, 05:09 PM

you should not unload a form in its terminate event as it's already unloading. also you should not need to reshow the Initial form-it should do that. so the button on the initial form should have code like

Please Login or Register  to view this content.

and the data entry form doesn't need handling when it is closed

**amotto11** · 03-06-2013, 05:15 PM

JP,

That works beautifully, thank you very much!

**JosephP** · 03-06-2013, 05:16 PM

you're welcome :-)

**amotto11** · 03-06-2013, 05:17 PM

well i tried to give you more rep, but sort of ironic i got this message "You must spread some Reputation around before giving it to JosephP again.". I guess it seems that you help me too much. Thanks again