Results 1 to 3 of 3

Thread: Extracting Values from colored cells

  1. #1
    Neophyte halfsparrow's Avatar
    Join Date
    Feb 2021
    Posts
    1
    Articles
    0
    Excel Version
    365

    Extracting Values from colored cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone,

    I am working in a project right now in vba and really need you help

    i have a userform in excel which is prepopulated when user opens a excel file



    Attached screenshot is of the demo excel file in that now i want the Level number Corresponding to red colored cell, what i mean here is cell for Level 6 (L6) is colored red so i want 6 in FirstAnchor Textbox in my userform
    and advance form is the vba code userformAdvanced Form.xlsm



    Please help.
    Thankyou in advance
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Screenshot (3).jpg 
Views:	14 
Size:	102.9 KB 
ID:	10360  

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,674
    Articles
    0
    Excel Version
    Office 365 Subscription
    This query has been cross-posted here: https://www.excelforum.com/excel-pro...ml#post5478956

    Please note that whilst it’s fine to post on multiple forums if you wish, we do ask you to declare it. Please read this to understand why: https://www.excelguru.ca/content.php?184
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,674
    Articles
    0
    Excel Version
    Office 365 Subscription
    Ali
    Enthusiastic self-taught user of MS 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
  •