• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Exctracting values from colored cells in vba


New Member
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

Upload Xlsx is 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

Please help.
Thankyou in advance


  • Upload.xlsx
    948.8 KB · Views: 0
Cross posted

Looks as though it's been solved on OzGrid
Last edited:
You should reread Forum Rules
There are clear instructions - what to do if really want to use cross-posting.
... and based same rules are everywhere.