userforms not opening in order

**DonG** · 11-30-2011, 11:55 PM

G'evening Everyone,

I've a simple problem here I'm sure. Attached is small WB and along with this text should demonstrate the problem I'm having.

Form 1 Shows when WB is opened.

Using the OptionButton and CommandButtons will take you from Form1 to Form2 and back again to Form1. (for now let's forget about Form3, the same thing happens with it so a solution to the problem will work with Form3 also.)

Selecting OptionButton1 and hitting CommandButton1 Hides Form1 and Shows Form2. When Form2 opens it displays the next numerical number in Row A in a TextBox window. Clicking the CommandButton places the value of TB in the next cell in Row A, clears the TB window and sends you back to Form1. This all works fine to here.

Now comes the problem....without closing the WB select OptionButton1 (Form1) again and click the CommandButton.....Form1 Hides and Form2 Shows, however the Textbox now is empty. I'm trying to make that Textbox show the next numerical number in Row A every time Form2 opens.

Any and all help will be greatly appreicated.....TIA,

Don

**pike** · 12-01-2011, 01:30 AM

Hi DonG

you need to swap the order of commands around

Please Login or Register  to view this content.

**DonG** · 12-01-2011, 11:33 AM

Originally Posted by pike

.......you need to swap the order of commands around......

Pike,

As I explained in PM, the code you posted exhibits the same behavior....i.e. The first cycle (Form1 to Form2 operates correctly) When you select Opt1 on Form1 the second time around, Form2 opens but the TB does not populate correctly.

Don