combobox code

[robert.begley1]

Hi Guys and Gals,
I have created a simple userform with three text boxes and a combo box
I have mabnaged to get the text boxes to work ok, and now have a drop down list in the combo box but I cannot figure the code to get the information from the combo box on to the spreadsheet with the command button even though i can get the textboxes to work properly code i have used for comand button is


private sub CommandButton1_Click()
Worksheets("Sheet1").Activate
erow = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Cells(erow, 1) = TextBox1.Text
Cells(erow, 2) = TextBox2.Text
Cells(erow, 4) = TextBox3.Text

End Sub

Thought if I add cells(erow,5)=combobox1.textthis should work, but it seems not
any help would be gratefully received
cheers
Rob

[jeffreybrown]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.