AhmedMatboly
09-13-2022, 05:49 AM
hi there ,
i have excel sheet which have serial number for the data in column a and i want the text1"textbox"to have default value which is last value in column a +1
pls review my code which i am sure its so bad coz i am newbie and thnx in advance ..
Text1.Value = Cells(Column, "a").End(x1up).cell.Value + 1
i have excel sheet which have serial number for the data in column a and i want the text1"textbox"to have default value which is last value in column a +1
pls review my code which i am sure its so bad coz i am newbie and thnx in advance ..
Text1.Value = Cells(Column, "a").End(x1up).cell.Value + 1