Enterkng data on a specific worksheet using a userform command button

Hello all,

I have a combobox that is referenced to a named list 'ListReels'. There are only 8 choices (Reels 1 -8), and each has an accompanying worksheet in the workbook. The user selects a reel, then inputs other information. When an 'Enter' command button is clicked, I had like the data to be entered onto the next available row of the worksheet with the same reel name (eg, if reel 2 is selected from the combobox, then the data should be added to the Reel 2 worksheet on the next blank row.

Thank in advance.
Frank

Hi Bernie,
thanks for the reply.....got busy with my day job and finally getting a chance to get back at what I was doing.

I don't think that is what I was looking for.
Here's what I am looking for.

1. A user form combo box has 8 items to choose from, Reel 1 to Reel 8.
(each item in the combo box represents a worksheet with the same name).

2. The user then enters 7 other bits of information using textboxes on the user form.

3. Then using a command button, I want the data to be entered onto the next available
row of the worksheet with the same name that was selected with the combo box (if the
user selected 'Reel 2' with thecombo box, then the rest of the data on the user form
should be entered on the next available row of the 'Reel 2' worksheet.

I hope this makes sense.

Frank

Hi Bernie,
thank you, thank you....

I just tried the code you sent and it works perfectly!!!

Your explanations helped immensely. I was able to follow along with what was happening and once I modified the names of the objects, it all worked.

Thanks again, now on to the next stage......