Greetings,
in my worksheet I have a userform which shows up on double click on a cell and displays data from some specific columns in the row of clicked cell (sort of 'record's short report')
Now I've added a textbox for user's comments for the record which I'd like to be stored in column named 'archive' (and displayed when the form is activated next time).
If I get it right, ControlSource property is what should do the job - and it does for one record and specific cell when typed like that:
but what I need is to set the source cell adress in some way like that:
My question is whether it does not work because of my code errors or maybe the reason is in some ControlSource property limitations?
TIA
in my worksheet I have a userform which shows up on double click on a cell and displays data from some specific columns in the row of clicked cell (sort of 'record's short report')
Now I've added a textbox for user's comments for the record which I'd like to be stored in column named 'archive' (and displayed when the form is activated next time).
If I get it right, ControlSource property is what should do the job - and it does for one record and specific cell when typed like that:
Code:
TextBox3.ControlSource = (CK2)
Code:
TextBox3.ControlSource = Cells(ActiveCell.Row, Range("archive").Column)TIA
