+ Reply to Thread
Results 1 to 4 of 4

Label to change if textbox has value

  1. #1
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    400

    Label to change if textbox has value

    Hi all,

    Can someone tell me if my code is correct? Im trying to show a lable caption if the textbox value = Y

    Note that the lable is not visible once i opened the userform:

    Please Login or Register  to view this content.
    and here's my code once i have va

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Label to change if textbox has value

    Looks OK to me, does it work?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    400

    Re: Label to change if textbox has value

    Hi Norie,

    apparently it doesnt work any ideas?

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Label to change if textbox has value

    How doesn't it work?

    Are you getting errors?

    Does the caption not get changed?

    When do you want the caption to change anyway?

    The code you posted will be executed when the button cmdSearch is clicked.

+ 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. Change userform label height without changing label width
    By vamosj in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-16-2015, 01:08 PM
  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. Replies: 11
    Last Post: 01-20-2015, 09:34 AM
  5. [SOLVED] Change the properties of a userforn textbox based on the backcolor of a label
    By chipnputt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2014, 10:47 PM
  6. [SOLVED] Change label caption's font color based on value in another textbox
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-19-2013, 01:59 PM
  7. Userform Textbox and Label change from cell
    By Panic in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-20-2008, 08:36 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