vb--simple simple

[stevieh]

hi,

anyone know how to copy a combobox selection to a specific cell b
using vb code in a command box

 

[stevieh]

i cant see this in the userform.

i know you can do this with a normal combo box which is not in a for
but lost when in a userform

 

[Jim Rech]

What's a "command box"?

Can you give an clear example of what you want to do?

--
Jim Rech
Excel MVP
| hi,
|
| anyone know how to copy a combobox selection to a specific cell by
| using vb code in a command box?
|
|
| ---
| Message posted
|

 

[stevieh]

in the form a command button would be pushed that would copy the dat
from the combo box (ie england) to a cell in the worksheet

does that help

 

[Jim Rech]

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


--
Jim Rech
Excel MVP
| in the form a command button would be pushed that would copy the data
| from the combo box (ie england) to a cell in the worksheet
|
| does that help?
|
|
| ---
| Message posted
|