vb--simple simple

S

stevieh

hi,

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

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
 
J

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?
|
|
| ---
|
|
 
S

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
 
J

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?
|
|
| ---
|
|
 
Top