Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Apr 2015
    Posts
    158
    Thanks
    72
    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,562
    Thanks
    384
    Thanked 1,480 Times in 1,346 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
    158
    Thanks
    72
    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,291
    Thanks
    3
    Thanked 198 Times in 184 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
    3,045
    Thanks
    145
    Thanked 541 Times in 516 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,291
    Thanks
    3
    Thanked 198 Times in 184 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
    1,019
    Thanks
    61
    Thanked 111 Times in 96 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,562
    Thanks
    384
    Thanked 1,480 Times in 1,346 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,291
    Thanks
    3
    Thanked 198 Times in 184 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
  •