Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Apr 2015
    Posts
    149
    Thanks
    67
    Thanked 0 Times in 0 Posts

    Using a Label Vs. a Text Box to Show Data from Worksheet Cells on a User Form

    Hello Pros,

    Is it best to use labels or text boxes to show text data from worksheet cells on a userform or does it matter?

    For example, if a worksheet cell has 25 words or more that need to be shown on a userform what are the pros and cons of labels vs. text boxes?

    Thanks

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    E.N.,

    If the data is static I would use a Label. If the data is dynamic I'd use a textbox. Remember you can always use the Locked property to keep the user from changing a textbox. HTH
    Last edited by RetiredGeek; 2016-03-05 at 16:22.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    Excelnewbie (2016-03-05)

  4. #3
    2 Star Lounger
    Join Date
    Apr 2015
    Posts
    149
    Thanks
    67
    Thanked 0 Times in 0 Posts
    RG

    As always, thanks for your help. Much appreciated.

  5. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Also, if you don't want the user to be able to copy the values, I'd use a label, otherwise a textbox.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. The Following 2 Users Say Thank You to rory For This Useful Post:

    Excelnewbie (2016-03-08),zeddy (2016-03-08)

  7. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts
    Hi rory

    ..that's worth remembering!


    zeddy

  8. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I've often wished they used a textbox in the built-in message box functions!
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #7
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Quote Originally Posted by rory View Post
    I've often wished they used a textbox in the built-in message box functions!
    Hear hear !

  10. #8
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Rory & Martin,

    Sure would make constructing messages a whole lot easier having word wrap wouldn't it!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  11. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    And being able to copy and paste into Google!
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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