abdo meghari
Well-known Member
- Joined
- Aug 3, 2021
- Messages
- 573
- Office Version
- 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
when fill row
when move to next row by enter then
so should ignore ITEM,CODE columns from cursor set focus totally
thanks
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
when fill row
when move to next row by enter then
so should ignore ITEM,CODE columns from cursor set focus totally
thanks