TextBox Control on a Userfrom

[jeff_kaufman]

I am attempting to walk a user through a userform by controling how the data entry. When the Userform is first activated the user is allowed to enter information in a textbox - once the information is entered the next textbox is enabled - the label highlighted - and I attempt to put the cursor in that textbox with the Setfocus property.

When I step through the code - the cursor does go to the proper textbox but then vanishes immediately. See my code below.

Can someone help me with what I am not doing correctly? Thanks.

Please Login or Register  to view this content.

[stnkynts]

I tried your code on a test workbook and it worked just fine for me. The cursor stayed in TextBox3 for at least a min or two. I'm using Excel 2010 but I doubt that would matter.

[Solus Rankin]

Jeff,

Are you stepping through the code with F8? Perhaps try testing the code by simply filling out the userform.

What I'm afraid is you're seeing the textbox lose focus when you press F8. The focus will actually be on the VBE.

[jeff_kaufman]

Still does not work for me - if I go back to Textbox 2 and re-enter the data and hit enter it then works - but the first time I enter data and hit enter, the cursor flashes in textbox 3 and then vanishes - any thoughts on this?

[jeff_kaufman]

I am not stepping through when this happens. I am also wondering if, for some reason, using the "afterupdate" is the culpret...

[jeff_kaufman]

Here is the file - if that helps. Would really like to figure this problem out because it is driving me crazy.

Thanks

[jeff_kaufman]

Doing some more testing -when the userform is activated I am disabling all the controls except for the first one. When the user enters data in the first textbox - I am enabling the second one and so on. When I remove the disabling and enabling feature the set focus works properly - so the error is connected to this somehow...

[Solus Rankin]

Is there a standard format for what is to me input to the textbox?

[jeff_kaufman]

Generally speaking it is just text and numbers depending on the prompot.

[Solus Rankin]

Is it a fixed length? I'm trying to find another way to determine when you're done with the first text box. Like:

Please Login or Register  to view this content.

[jeff_kaufman]

Well - did not get it figured out today - so I needed to find a way around it. I was able to change the "enabled" property to "locked" and get the desired effect - I also believe there are problems moving from between Frames so I got rid of those.

Thanks for your help.

Jeff