View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default how do I copy from textbox or combobox into a cell

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" wrote in message
...
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?