ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do I copy from textbox or combobox into a cell (https://www.excelbanter.com/excel-programming/335365-how-do-i-copy-textbox-combobox-into-cell.html)

Peterke

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?



Nigel

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?






All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com