ExcelBanter - r/t 2110 - Can't Move Focus to control

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - r/t 2110 - Can't Move Focus to control (https://www.excelbanter.com/excel-programming/419848-r-t-2110-cant-move-focus-control.html)

JMay

r/t 2110 - Can't Move Focus to control

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

JMay

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

All times are GMT +1. The time now is 04:47 PM.