Results 1 to 3 of 3

Thread: Extracting Values from colored cells

Threaded View

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

    Extracting Values from colored cells

    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:	10 
Size:	102.9 KB 
ID:	10360  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •