Userform ComboBox to Excel's Cell

[CESAR V. ARROYO]

Can someone help to take the selected option in my combo box to worksheet "quote"/cell D2.

Please Login or Register  to view this content.

thanks

[Leith Ross]

Hello Cesar,

Por favor, ayuda me entender. This is post is confusing.

Where is this Sub located: in a UserForm or in a Module?
Is the ComboBox located on the Userform "Customer_Validation"?

[CESAR V. ARROYO]

Hello Cesar,

Por favor, ayuda me entender. This is post is confusing.

Where is this Sub located: in a UserForm or in a Module?
Is the ComboBox located on the Userform "Customer_Validation"?

The Sub is located in a Module, and yes it is located on the Userform "Customer_Validation".

[Leith Ross]

Hello Cesar,

The ComboBox selection can be copied most easily by using the ComboBox_Click() event on the UserForm. Change the ComboBox name from CustomerComboBox To what you are using. Copy the code below to the UserForm "Customer_Validation".

Please Login or Register  to view this content.