Drop Down list with color

[jerrypatos]

Hi, I am new to excel vba and need your help.

My table consist of several lines like the example I attach.

I want to automatically create a drop list or update an already created one when the code (loop? I dont know) finds color Grey . Then pick the name of that cell and create a new item at drop down in order when select it to go to that cell.

Is this possible?

Cheers!

[KOKOSEK]

So, you need 2 macros.

1st to create/update dropdown list, into standard module:

Please Login or Register  to view this content.

I do not understand that how do you want to trigger it to rebuild but it will create drop-down in B2 with values from grey cells.

2nd into sheet code (based on chosen value from drop-down, value is found and select):

Please Login or Register  to view this content.

[jerrypatos]

Dear KOKOSE

Thank you for your reply!

I was wondering if this can be done with range of cells , ie B12:B1000 and I12:1000 I tried but no luck.

[KOKOSEK]

Do you mean instead of

Please Login or Register  to view this content.

check colours also in other ranges (B12:B1000 and I12:I10000)?

Try like this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.