Hi there
I'm new to VBA. I know just enough to be dangerous to myself.
I have been creating a work book over the last 10 years that I use in my
business and now want to make it user friendly by way of user forms.

Having created a excel userform in vba, I want to use this form for placing
data into a worksheet(s) Each time I open the form I want to place new data
onto the next available empty row.
My form has a mixture of some 20 text boxes, links to other userforms &
lists and I want the information to go into a seperate column but on the same
row. however not all the text boxes etc will have data in them.

Also I want to be able to use the form to edit previous data that has been
entered. For example row 6 may need to have the data edited and I want to be
able to select that by way of code, say Ext002, in the first column.

Your help would be much appreciated.