How to rename a textbox

[Jim P]

When you add a textbox, excel generates a name "Textbox
1" etc. I would like to rename it so that I can have a
constant and more meaningful name to it. I also need to
add data to it from VB6. Any help is appreciated.

Thanks

 

[Harald Staff]

There are textboxes, textboxes and textboxes. If it's a control, rename it
in its "Properties" window -the Name property to be exact.

Please explain "add data to it from VB6"

 

[Guest]

It is an Excel textbox (Shape). I need to send data to it
from VB6. application.worksheet.????.

Thanks,

Jim

 

[Harald Staff]

It is an Excel textbox (Shape).

Rename it in the name box, above 1, left of A, where your active cell
address displays its address. Finish entry with Enter.

I need to send data to it
from VB6. application.worksheet.????.

Record an Excel macro while entering manually. Excel macros are in VB6, so
you should be almost there when done.

HTH. Best wishes Harald