Extracting Values from colored cells

halfsparrow · Feb 25, 2021

[FONT=&quot]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[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]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 userformView attachment Advanced Form.xlsm[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Please help.[/FONT]
[FONT=&quot]Thankyou in advance[/FONT]

AliGW · Feb 25, 2021

This query has been cross-posted here: https://www.excelforum.com/excel-pr...ng-values-from-colored-cells.html#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 · Feb 26, 2021

Also x-posted:

https://chandoo.org/forum/threads/exctracting-values-from-colored-cells-in-vba.45865/
https://www.ozgrid.com/forum/index....rom-colored-cells/&postID=1245275#post1245275

SOLVED on OzGrid.

Extracting Values from colored cells

halfsparrow

New member

Attachments

AliGW

Administrator

AliGW

Administrator