Dear all,
I have 10 freeform objects or shapes that I have created by drawing tool (PC
Excel 2003) and have grouped them (Group1...Group10).
I am wondering if it is possible to create a drop-down menu which shows
miniature shapes of the Group1...Group10 instead of using text. I want the
operator be able to see all the shapes and then decide which one to click to
choose from.
I know this can be done with text but I need to have this menu with actual
shapes as it is difficult to convert the visual graphic to some descriptive
text in my project.
Thanks for any comments.
DORI

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

Another possibility is a user form with pictures of the 10 groups and
an option button next to each.

Ken Johnson

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