I have a Userform List box where I can select values (in this case Date) with a check box and a button that copies the values to a cell.
I can select as many values as I like. Unfortunaely, all the values are populated into 1 cell
What I intend, is to select no more than 3 values and paste to a range of cells in a column
So,
first value would be pasted in to cells A5,A10, A15, ....,A35
and if a Second value selected, then would be pasted into cells A6, a11, A16, ....,A36
and if a third value selected, then would be pasted into A7, A12, a17, ..., A37.
Can I do this from a Userform List box. If so, how? If not, the best way forward.
Many thanks for any assistance.
I have tried to download a copy of the work sheet, but 'The uploaded file does not have an allowed extension' message appears
Easy59
I can select as many values as I like. Unfortunaely, all the values are populated into 1 cell
What I intend, is to select no more than 3 values and paste to a range of cells in a column
So,
first value would be pasted in to cells A5,A10, A15, ....,A35
and if a Second value selected, then would be pasted into cells A6, a11, A16, ....,A36
and if a third value selected, then would be pasted into A7, A12, a17, ..., A37.
Can I do this from a Userform List box. If so, how? If not, the best way forward.
Many thanks for any assistance.
I have tried to download a copy of the work sheet, but 'The uploaded file does not have an allowed extension' message appears
Easy59