how do I copy from textbox or combobox into a cell

P

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?
 
N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
VBA - Calendar with more than 1 textbox 9
Combobox problem, please help this novice! 5
Textbox data to cell 5
use ComboBox value to select range and then use selected range tocreate a chart 3
Combobox with textbox and Commandbutton 4
userform information copy to a cell 7
copy text from textbox to another application 3

Top