+ Reply to Thread
Results 1 to 2 of 2

Conditional Format Multiple Userform Textboxes dependent on value

  1. #1
    Registered User
    Join Date
    02-09-2016
    Location
    Wales
    MS-Off Ver
    2010
    Posts
    16

    Conditional Format Multiple Userform Textboxes dependent on value

    Hi,

    I have 58 text boxes all of which can have a value from -32 to 40 and im trying to set a colour od the textbox dependant on its number,

    between -32 and -3 is one colour
    between -2 on 0 is another colour
    and
    between 1 and 40 is another colour.

    Ive tried using various bit of code but cant quite get anything to work.

    Has anyone got any insights to share?

    Thanks in advance

    The below code is the closest I have got,

    I have also posted this here http://www.ozgrid.com/forum/showthre...767#post773767

    Please Login or Register  to view this content.
    Last edited by Ghostmonkey; 07-12-2016 at 09:18 AM.

  2. #2
    Registered User
    Join Date
    02-09-2016
    Location
    Wales
    MS-Off Ver
    2010
    Posts
    16

    Re: Conditional Format Multiple Userform Textboxes dependent on value

    Anyone able to offer any advice or help with this?

    Many thanks

+ 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. VBA Userform Multiple Textboxes to Find Record
    By chamowllie01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2016, 10:06 AM
  2. Format Multiple Textboxes at once in a Userform
    By Dan... in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2015, 05:34 PM
  3. [SOLVED] Changing multiple textboxes format on a userform
    By Raylou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2014, 10:11 AM
  4. [SOLVED] Curency format in textboxes of userform
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-11-2014, 12:36 PM
  5. 3 dependent textboxes in a userform
    By Leandrial in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2012, 01:24 PM
  6. Formatting Multiple Userform Textboxes
    By badeye in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-01-2010, 09:14 AM
  7. Is there a way to format all TextBoxes on a UserForm the same at one time?
    By D3Pratt in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-02-2009, 09:09 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