How to rename a textbox

  • Thread starter Thread starter Jim P
  • Start date Start date
J

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
 
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"
 
It is an Excel textbox (Shape). I need to send data to it
from VB6. application.worksheet.????.

Thanks,

Jim
 
It is an Excel textbox (Shape).
Click to expand...

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.????.
Click to expand...

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

HTH. Best wishes Harald
 
Back
Top