Copy a cell content into a TextBox

G

Guest

Is there a way to copy a cell content into a TextBox with a macro? If i try
to register the steps it doesn't work.

I have to fill many textbox (is "textbox" correct? I've the italian version
and it's "casella di testo"..) at once with data from a form.

bye!
 
T

Tom Ogilvy

What kind of textbox. Is it from the control toolbox toolbar or from the
drawing toolbar. Where is the textbox located - Worksheet, Userform,
DialogSheet?

In any event, unless the length of the text is very long

object_qualifier.TextBox1.Text = Worksheets("Sheet1").Range("A1").Value
 

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

Help with TEXTBOX control 2
Copy value of textbox to clipboard for use in another application 5
finding where text wraps in a textbox 4
erase field textbox 4
Print textbox-content possible? 3
Delete enter key rectangles in a cell. 2
copy text from textbox to another application 3
How to paste clipboard into textbox sheet? 4

Top