+ Reply to Thread
Results 1 to 4 of 4

Make a TextBox look like a Label

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Make a TextBox look like a Label

    I want to make a TextBox look like a Label because reasons.

    At the same time, I want to keep its scrollbars usable. Doable?

    I tried online searches but my filter bubble keeps showing me results for making a Label look like a TextBox - not what I am looking for!
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Make a TextBox look like a Label

    Set its back colour to transparent, border to none and special effect to flat.

    Is that close enough?

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Make a TextBox look like a Label

    Quote Originally Posted by Kyle123 View Post
    Set its back colour to transparent, border to none and special effect to flat.

    Is that close enough?
    Yep. Thanks

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Make a TextBox look like a Label

    Great, tanks for the rep

+ 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. Label to change if textbox has value
    By geliedee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2016, 04:10 AM
  2. [SOLVED] Excel 2010 - Userform - display date from textbox in a label or textbox in 'ddd' format
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 10:54 PM
  3. MultiLine TextBox line count to display in label or textbox
    By khhoa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2015, 06:02 PM
  4. [SOLVED] Label & textbox
    By molesy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2014, 12:42 PM
  5. Label Visible By Value in TextBox
    By billykiller05 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2009, 12:42 PM
  6. Textbox / label names
    By cremate in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2008, 03:27 PM
  7. TextBox and Label Assignment
    By oht in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2006, 04:58 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