Cam
03-03-2014, 07:11 AM
Hey to all that views this thread.
It's probably an easy solution, but...
I have a userform from which data is saved to a dataprint worksheet starting from B53:M53 and on the same sheet (A1:L51) is a printable form from which the user can select data from a combobox control on the worksheet to print.
However, I am hoping someone can tell/show me how to increment numbers from 1~ , on column A starting from row 53 before the data is save to the next row. it's for the worksheet combobox. It does'nt accept words as a value, only numbers starting from 1.
It's probably an easy solution, but...
I have a userform from which data is saved to a dataprint worksheet starting from B53:M53 and on the same sheet (A1:L51) is a printable form from which the user can select data from a combobox control on the worksheet to print.
However, I am hoping someone can tell/show me how to increment numbers from 1~ , on column A starting from row 53 before the data is save to the next row. it's for the worksheet combobox. It does'nt accept words as a value, only numbers starting from 1.