ComboBox Selection to a Cell

[CESAR V. ARROYO]

Hello,

Can someone help me to figure out how to place the selected value on my Userform "UserForm_CustomerSelection" into Cell B5.

The value selection is made out of a ComboBox called "ComboBox-CustomerSelection".

Sub EstimateTemplate()
    ClearContents
    CustomerSelection
End Sub
Sub ClearContents()
'Clears Customer Data
    With Range("Customer_Name,Customer_Address,Customer_Phones,Company_Contact") _
    .ClearContents
'Clears Project Data
    With Range("Project_Name,Project_Address,Project_City") _
    .ClearContents
    End With
    End With
End Sub
Sub CustomerSelection()
    UserForm_CustomerSelection.Show
End Sub

[Richard Buttrey]

Hi,

You could either use the ControlSource property of the combobox and enter B15, or better still name the B15 cell and use the name in the ControlSource property instead.

Alternatively explicitly enter the combobox value to B15 with a combobox event, e.g. the Change event. i.e.

Sheet1.Range("B15") = UserForm_CustomerSelection.ComboBox-CustomerSelection