Command Button Output text

Hi everyone I need help coding a command button to output text based on the contents of combobox1 and combobox2. The text should be placed in the next available cell starting in cell b3 for combobox1 and starting in cell c3 for combobox2. Each time submit is clicked the name and number associated with that name should go in the next free cell in the spreadsheet.

So for example the user choses name1 and number6 cell b3 would read name1 and cell c3 would read number6 after submit is clicked. The user then choses name58 and number12 and presses submit again cell b4 would read name58 and cell c4 would read number12.

Anyhelp with this?

use this in your command button click event, i'm assuming you have data in column b to rows 3 and the same with C

Please Login or Register  to view this content.

Where are the comboboxes & button - on the sheet or a userform?

The code should will with controls on the sheet.