Copy a cell content into a TextBox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

snaggy^^ - 19 Jan 2006 18:45 GMT

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!

Reply to this Message

Tom Ogilvy - 19 Jan 2006 22:40 GMT

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

Signature

Regards,
Tom Ogilvy

> 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.
[quoted text clipped - 3 lines]
>
> bye!

Reply to this Message