You are probably using a Worksheet_Change event macro. Such a macro fires
only if the contents of a cell change. If your drop-down has only one
value, then selecting that one value will not change the contents of the
cell and the macro will not fire. Perhaps a Worksheet_SelectionChange macro
will work for you. HTH Otto
"geebee" (noSPAMs) wrote in message
...
hi,

i have some code on dropdown change... but noticed that it really doesnt
execute when there is only one value available for selection. like it
works
if you have more than one value to be selected, but if there is only one,
it
really doesnt trigger anything...

any ideas?

thanks in advance,
geebee