You can use code like this to place the value of the combo box in a
cell.

Private Sub ComboBox1_Change()
Range("A1").Value = ComboBox1.Value
End Sub

that is very basic code that will enter the value in a cell whenever
the combobox changes.

Hope that helps.

theSquirrel




On Dec 12, 11:36 am, "Hector Fernandez"
wrote:
I've looked for quite some time for a solution, but can't seem to find
it.

All I want to do is make a combo box in an User Form that works just
like the combo box in the Forms toolbar.

I can get the User Form combo box to show a range of options from which
to choose from (same as the Input Range Control for the combo box in
Forms, but I can't for the life of me figure out how to get it to
simply put in a number in a linked cell (as the Forms toolbox does).

With forms, the selection you make puts a number, depending on the
combo box choice, in the Linked Cell of my choice. I want to do
exactly the same thing with the User Form combo box - HELP