Conditional code when drop down has been activated

[EngineeringScientist]

Trying to write code so that a shape moves when the drop down menu has been selected.

Basically I want a flag to appear underneath the drop box, but I only want the flag to "drop down" when the combobox drop down list has been selected, ie. when the user presses teh arrow to display the drop down list, the flag will be under the combobox list.

I'm having trouble with this as I can't find anyway for excel to know if the dropdown list specifically has been clicked, it only seems to react if the combobox has been selected or a value in the drop down list clicked.

Please respond with any ideas, or ask for more clarification of problem.

Cheers!

[jeffreybrown]

Maybe you could expound upon why?

What are trying to achieve with this flag?

What is it supposed to represent to the user?

[EngineeringScientist]

I am designing an archery shop as part of a university group project.

I am designing the arrows section of the shop.

My idea is to have a big arrow with drop down menus attached, for selecting different properties of the arrows. My plan is to have the user click on the drop down menus and flags to fall down behind the drop down list.

[jeffreybrown]

Okay, sounds like an industrious project and quite honestly I have no idea.

Let me ping the real professionals and see if they have some thoughts...

[JosephP]

if you use an activex combobox it has a dropbuttonclick event you might use or you could use a listview control with pictures assigned to the items

[EngineeringScientist]

Thanks! That's exactly what I needed.

Got it working now.

[jeffreybrown]

Many thanks to JosephP...

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save