• 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

    Hui...

  • 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

halfsparrow

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
 

Attachments

  • Upload.xlsx
    948.8 KB · Views: 0
Cross posted
https://chandoo.org/forum/threads/ex...-in-vba.45865/
https://www.ozgrid.com/forum/index.p...75#post1245275

Looks as though it's been solved on OzGrid
 
Last edited:
halfsparrow
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.
 
Back
Top