Hi Ken,
I am glad that you noticed my posting.
Yes, that works for my project. Would it be possible to hide all the
miniatures once one of them has been clicked on?
Thanks for your help.
DORI

"Ken Johnson" wrote:

Hi DORI,

I'm reasonably sure that can't be done.

You could however make your 10 miniatures then position them close to
the cell where you were considering having the drop down.
Each of the miniatures can be assigned to the same macro. This macro
could detect which miniature was clicked.
If all the miniatures are normally not visible, you could use a
Worksheet_SelectionChange Event Sub to make them all visible when the
user clicks in the cell about which they are arranged.
After they become visible the user can click on their choice. This runs
the macro that could then place an appropriate value into the cell as
well as remove the miniatures from view.

Does this sound like a suitable alternative?

Ken Johnson