how do I copy from textbox or combobox into a cell

[Peterke]

Hi,

I'm trying to create a userform with textboxes and comboboxes, but don't
know how to cut & paste from a textbox or combobox into a single cell on the
worksheet using a commandbutton.

Can someone help me please?

[Nigel]

Use an event for the commandbutton to copy the contents of the textbox or
combobox.

Eg.....

Private Sub CommandButton1_Click()
Worksheets("Sheet1").Range("A1") = TextBox1.Value
End Sub


--
Cheers
Nigel



"Peterke" <[email protected]> wrote in message
news:%[email protected]...
> Hi,
>
> I'm trying to create a userform with textboxes and comboboxes, but don't
> know how to cut & paste from a textbox or combobox into a single cell on
the
> worksheet using a commandbutton.
>
> Can someone help me please?
>
>