How to create a standard text box with bullet points with vba

[treygon]

I would like to create and insert a text box (not a form text box) that has bullet points and other formatting using vba. I've tried to research this but haven't had luck.

Any ideas?

 

[pedie]

Textbox with bullets and formatting? I'm not sure what you mean..
What are you trying to do if I may ask...

 

[treygon]

Textbox with bullets and formatting? I'm not sure what you mean..
What are you trying to do if I may ask...

In a standard spreadsheet you can go the "Insert" menu tab and then click on the "Text box" icon. This allows you to draw a text box in the spreadsheet. In this text box you can add text, indent text, add bullets, format text, etc.

I tried recording myself doing this and adding bullets, but it didn't record anything...

Any ideas?

 

[treygon]

Recording a macro doesn't work when trying to do this...any ideas??!!