Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I copy from textbox or combobox into a cell
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cell font colour to textbox? | Excel Discussion (Misc queries) | |||
combobox /textbox value | Excel Discussion (Misc queries) | |||
copy cell contents to a textbox 255 characters | Excel Programming | |||
Combobox with textbox and Commandbutton | Excel Programming | |||
Userform ComboBox and TextBox help!!! | Excel Programming |