Extracting Values from colored cells

[halfsparrow]

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

[AliGW]

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

[AliGW]

Also x-posted:

https://chandoo.org/forum/threads/ex...-in-vba.45865/
https://www.ozgrid.com/forum/index.p...75#post1245275

SOLVED on OzGrid.