VBA userform to do add a value into a table? For a combo box?

[LIL2606]

Hi all,

This should be simple, but I can't really put it together, my brain doesn't function today..

I have a Userform with a text box, and it copies a template from Sheet1 into Sheet2, and inputs the value of the textbox into the pasted template's name cell on Sheet2, every time I press this button, a new section is to be added to Sheet2, below the previous one with a different name, but I would also like it to input these names, into a table on Sheet1.

At least.. I think thats what I want. The plan is, to then create another Userform, which will have a drop down list created from this table, or is it better if its not a table just a named range? I just want it to be dynamic, it is just 1 column.

If its best to do the table how do I do this line?

SG_Names_LR = Sheet1.ListObjects("Table1").Range.Rows.Count

Sheet1.Cells(SG_Names_LR + 1, 1).Value = Name_SG_Textbox.Value

As currently it adds the new name under the (manually created) table, not into it.

Or is it supposed to be something like - If this is the first item in this range, then create a table called Table1, otherwise add a row? Or how?

Please help!

[SjonR]

try this:

Sheet1.ListObjects("Table1").ListRows.Add.Range(1) = Name_SG_Textbox.Value

[LIL2606]

Oh amazing! Thank you!!

[SjonR]

You're welcome