jump & skip cursor set focus for two columns on userform when try set focus into textbox

abdo meghari

Active Member
Joined
Aug 3, 2021
Messages
465
Office Version
  1. 2019
Hello
first thanks for mr.Dante Amore for gives me choice how doesn't move cursor before fill the textbox for each individually as in this link
don't move set focus cursor to next textbox on userform if the previous textbox for the same row is empty
complement to this project I need skip cursor set focus two columns ITEM,CODE on userform
the ITEM column contains textboxes numbers(textbox 66,73,80,87,94,101,108,115,122,129,136).
the CODE column contains textboxes numbers(textbox 67,74,81,88,95,102,109,116,123,130,137).
the BRAND column contains textboxes numbers(textbox 68,75,82,89,96,103,110,117,124,131,138).
the TYPE column contains textboxes numbers(textbox 69,76,83,90,97,104,111,118,125,132,139).
the ORIGIN column contains textboxes numbers(textbox 70,77,84,91,98,105,112,119,126,133,140).
the COSTING column contains textboxes numbers(textbox 71,78,85,92,99,106,113,120,127,134,141).
the SELLING column contains textboxes numbers(textbox 72,79,86,93,100,107,114,121,128,135,142).
so what I want when try cursor set focus in column ITEM OR CODE should n't cursor set focus for any textbox for two column just start from BARND column and when fill the row start textbox from column BARND then move to next textbox under column BRAND and so on (just ignore columns (ITEM,CODE)
the column ITEM,CODE will populate automatically when fill textboxes from BARND column to ORIGIN column .

when start running userform will start from first textbox for BRAND column
1.PNG


when fill row
2.PNG


when move to next row by enter then
3.PNG


so should ignore ITEM,CODE columns from cursor set focus totally
thanks
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,214,827
Messages
6,121,824
Members
449,050
Latest member
Bradel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top