View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
 
Posts: 468
Default r/t 2110 - Can't Move Focus to control

Never mind, Found googling:

Me.MultiPage1.Value = 0
TextBox1.SetFocus

Now works fine!!

"JMay" wrote:

I have Userform1 with 3 pages

On My page1 I have TextBox1 inside Frame1

Once I enter all data covering the 3 pages and I update my database
I want in the next line of code to RETURN (set focus) to my Page1 - Textbox1

Currently using: (but it is not working) - What must I do?

UserForm1.Page1.TextBox1.SetFocus