Drop down list question

[Alex01]

when a drop list is present in a cell it just remains blank. is there a way to indicate that a drop down list exists in a cell?

thanks in advance

[VBA Noob]

You could

add a comment
http://www.contextures.com/xlcomments01.html
or add a validation message
http://www.contextures.com/xlDataVal04.html
or colour the cell

To select all cells press F5 > special > validation

Macro will colour them yellow

Please Login or Register  to view this content.

VBA Noob

[Alex01]

You could

add a comment
http://www.contextures.com/xlcomments01.html
or add a validation message
http://www.contextures.com/xlDataVal04.html
or colour the cell

To select all cells press F5 > special > validation

Macro will colour them yellow

Please Login or Register  to view this content.

VBA Noob

many thanks VBA Noob.

i chose comment, liked the red mark.

[VBA Noob]

Glad it helped

VBA Noob