Sequential Method to Set Focusing of Text Boxes

Dear Experts,

It may be very simple task, but l am unable incorporate with my code.

Need your support on the same. I have built a Userform which contains below listed Text & Combo Boxes in it!

Label Name: Boxes Name: Updation Method: -

Label 1 Date_ (Text Box) Auto Update
Label15 Data_Entry (Text Box) Auto Update
Label2 Page_No (Text Box) Manual Update
Label5 Zone (Text Box) Manual Update
Label3 PartNumber (Combo Box) Manual Update
Label4 Description Auto Update
Label6 Category (Combo Box) Manual Update
Label7 C_LL (Text Box) Manual Update
Label8 Colour Manual Update
Label11 UOM_CC Manual Update
Label13 UOM_MM Auto Update
Label14 UOM_Check Auto Update
Label9 Qty Manual Update
Label10 F_Qty Auto Update

Below is the code which is been built and it is working very much find. However, since I am new VBA, I am unable to incorporate “SetFocus” Sequence as per my Need!

Focusing appropriate cell is mandatory because it is used by multiple users!

Please help me to add code along with below codes to meet following set focus sequence:-

By Default, when “userform” Initialize it keeps setfocus to “Page No” .

1. After updation of “Page No”, cursor has to focus on “Zone”
2. After Update cursor has to focus on “PartNumber”
3. After Update cursor has to focus on “Category”
4. After Update cursor has to focus on “UOM_CC”
5. After Update Cursor has to focus on “Qty”

Looking forward your valuable input!

Please Login or Register  to view this content.

Thanks & Regards,
Rajeshkumar R

I use the Change_Event with a suitable condition to verify the imput in each box - here are a few examples
If user forced to select value from list (combobox) then selection triggers focus set to next box
see attached workbook

Please Login or Register  to view this content.

Why not just set the TabIndex of your objects in the wright order starting from 0 for Page No, 1 for Zone, ....