![]() |
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? |
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