Text Boxes: Insert/Text Box vs. Developer Text Boxes

[snapfade]

I have routinely inserted a text box to contain notes. I am curious, what is the difference between the simple text box found on the Insert Ribbon compared to the developer text box control?

Aside from having many more properties options with the VBA version, is there really a difference? Can they be used interchangeably?

Just wonering....

snapfade

[Jakobshavn]

If all you need is a box to hold comments, the simple Drawing textbox is good enough. Controls textboxes in UserForms are a convenient way to gather user inputs.

[snapfade]

Makes sense. Where would I find in-depth list of Text Box properties?

[Jakobshavn]

That is a good question. Within Visual Basic, I would look at what the Object Model says for Properties and Methods. Another simpler approach is to create a TextBox and right-click it.

[snapfade]

Good point. I have been searching "Excel" left and right but nada. VB makes sense. thx

[vlady]

@ Snapfade

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
Being new to the forum for the meantime I'll do it for you.

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.