+ Reply to Thread
Results 1 to 4 of 4

Change the properties of a userforn textbox based on the backcolor of a label

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    26

    Change the properties of a userforn textbox based on the backcolor of a label

    The code below is for a userform that is created at runtime. The form lists all of the possible selections that a user may chosen in the Data Entry sheet and he can enter the order he would like to see the results in a report sheet. I would like to improve the design of the form by changing the backcolor of the label of the unused items, clear and disable the corresponding textbox. The following code changes the backcolor but I am stumped getting to the corresponding textbox. Can anyone help?
    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Change the properties of a userforn textbox based on the backcolor of a label

    Try something like this (not tested)

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    05-30-2012
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    26

    Re: Change the properties of a userforn textbox based on the backcolor of a label

    AlphaFrog thank you for your assistance. Had to modify the code a little but you placed me on the right track.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Change the properties of a userforn textbox based on the backcolor of a label

    You're welcome and thanks for the feedback.

+ 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. [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
  2. change the backcolor based on excel value
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2011, 04:55 AM
  3. Change TextBox BackColor
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2010, 05:07 PM
  4. Change Textbox Backcolor (multiple textboxes)
    By msommerf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2010, 10:52 AM
  5. Change textbox backcolor then save workbook?
    By danny2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2008, 07:52 AM

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