Add a textbox using VBA

[BigBas]

Is there any VBA code that can add a textbox to a worksheet?

I have a worksheet, and if certain conditions are met, I would like a textbox containing certain information to be added to the worksheet. I do not want the information itself to be enterred into the cells, but I would like it to be visible in this textbox when I print out the report.

Can anyone guide me in the right direction?

Thank you.

[Leith Ross]

Hello BigBas,

Here is macro to insert a TextBox on the ActiveSheet at cell "E3". You can change the size properties to what you need.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[BigBas]

Thanks Leith. Works as needed. But how do I populate the textbox with text using VBA. I assume it would be code like : textbox1.text = "Insert Text"

But, how do I know what the name of the textbox is? Thanks in advance for the help.

[Leith Ross]

Hello BigBas,

I thought about that after I posted the code. I have added a Public variable to hold the name of the TextBox. All the code goes in the same module.

Please Login or Register  to view this content.

When referencing OLE Objects, you should qualify them with the Worksheet the object belongs to. Otherwise, VBA assumes you mean the ActiveSheet, and if there are no OLE Objects you get an error.

Inserting Text Example

Please Login or Register  to view this content.

Sincerely,
Leith Ross