UserForm

[Az_Outlaw]

Hello everyone,

I am having problems setting up my user form and would appreciate it if someone could help me.

I have a shared workbook that many people use (each person has own sheet) and one user form to enter in the data. This is what I want to do....can someone help me translate this to code?

After the user clicks on the "Add" button on the form this is what I want to happen.

Please Login or Register  to view this content.

Additionally, I don't know how to determine the next empty row. I need it to look at column B as I have numbers in column A.

I just don't know how to write what I want to do and I am really lost...If someone could help me I would greatly appreciate it. I have attached the workbook.


Thanks again,
John

[romperstomper]

Try this:

Please Login or Register  to view this content.

[Az_Outlaw]

This is very helpful, thank you! This works but I am not sure how to populate a combo box with a list....I have a named range in my workbook, can I use this range?

[romperstomper]

Yes, you can:

Please Login or Register  to view this content.

is the basic syntax.