+ Reply to Thread
Results 1 to 2 of 2

Textbox vs shape

  1. #1
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Textbox vs shape

    Hi

    I'm considering using textboxes or shapes to create some form of form that is filled in from a table of data. Is there any benefit/drawback or fundamental difference in using shapes instead of textboxes for text? When you add text to a shape, does it become a textbox then or what? It seems like the text resides in a TextFrame either way.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Textbox vs shape

    Hi Jacc,

    TextBoxes are designed to be used to read and write text. Shapes are designed to be static entities, however Shapes can read and write text. It is slightly more difficult to manually write text in a Shape. Shapes probably have more flexibility with updating attributes such as background color.

    My personal first choice for this type of application would be a UserForm, due to ease of designing where things go, and ease of data entry/retrieval. However, UserForms generally are not pretty to look at.

    I hope this helps you make up your mind.

    Lewis

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Shape buttons - Switch background image of shape on click and exit - referenced jpg
    By ApatheticAndrew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2015, 08:06 AM
  2. Replies: 13
    Last Post: 12-10-2013, 12:51 PM
  3. Problems creating a shape textbox in word 2010
    By tfurnivall in forum Word Formatting & General
    Replies: 8
    Last Post: 12-17-2012, 10:53 PM
  4. Replies: 0
    Last Post: 11-30-2012, 01:29 PM
  5. Is Shape a textbox
    By sanjay in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-05-2008, 08:28 PM
  6. [SOLVED] Adding shape-type textbox into excel chart sheet
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2006, 03:30 AM
  7. [SOLVED] Interesting problem with VBA generated textbox (or textframe of shape) length
    By Bill Dilworth in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2005, 12:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1