Hi,
I am trying to standardise data outputs. Therefore I have created a userform in which i can fill in my data in multiple text/comboboxes. Whay I want to do is, using a commandbutton, copy the values to a seperate excel sheet. There I want the value to be copied to the first available empty row.
For instance:
I have a textbox (textbox1) called 'name'. I can copy the value to a specific cell using Range("A2") = TextBox1 'test_id
What i want is to copy the value from textbox1 to the first available free cel (preferrably the first free row) in column A.
Cheers,
Xcptpack
I am trying to standardise data outputs. Therefore I have created a userform in which i can fill in my data in multiple text/comboboxes. Whay I want to do is, using a commandbutton, copy the values to a seperate excel sheet. There I want the value to be copied to the first available empty row.
For instance:
I have a textbox (textbox1) called 'name'. I can copy the value to a specific cell using Range("A2") = TextBox1 'test_id
What i want is to copy the value from textbox1 to the first available free cel (preferrably the first free row) in column A.
Cheers,
Xcptpack