Set Focus To TextBox on UserForm

[tsrwebman]

I have posted a copy of my SS athttp://www.telfordsteamrailway.co.uk...cker_weekh.xls

On the summary page click on 'Enter Sale' and notice that Customer Advisor' text box gets the focus and the cursor is flashing. (Which is what I want).
Enter any name and a sale value (say 'A' and '1') and click the 'OK' button
But when I tried to enter another sale the OK button still had the focus.

So in the VBA Project / Forms / frm_sale / OK Click event - near the bottom
I added a set focus before the 'frm_sale.hide' - This removed the focus from the 'OK' box - but the cursor is still not in the text box, and it needs to be clicked in order to enter text.

This is clearly something trivial I am missing - but the blinkers are on and I cant spot it

Help appreciated.

[Dave Hawley]

POOR THREAD TITLE Please read THIS PAGE and THIS PAGE IN FULL

TextBox1.SetFocus 

[tsrwebman]

Re title - understood, better more fully descriptive next time

But

textbox.setfocus doesnt work - see posted code

Allan

[Dave Hawley]

Works for me.

[Andy Pope]

Move the ca_name.Setfocus from the end of the Ok_Button event to the Userform Activate event

 'clear form
Call clear_button_Click 
 
 'aaaarggggh
 
 ''    ca_name.SetFocus
frm_sale.Hide 

Private Sub UserForm_Activate() 
     
    ca_name.SetFocus 
     
End Sub 

[tsrwebman]

cheers Andy - that got it

Allan