Excel Excel: Copy data from textbox to first empty row in specific column

Oct 8, 2009
Reaction score

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question