Auto Show Drop-Down List When Selecting the Cell

[DocAElstein]

Thanks for letting us know.
This is good news.
It is very interesting. I just tried it, and it works for me too, in Excels 2003 2007 and 2010
I would never have thought it possible!
I am always very pleased when I am proved wrong about something in VBA, because it usually reveals something very interesting and useful. It does not happen very often, but when it does it usually reveals something very interesting and useful for me also. It is nice to be in a position to allow me to look forward to being proved wrong. ( I have seen that most professional programmers, and senior forum members get very upset when they are proved wrong, and so try to hide it, which often means that interesting things like this never get to be seen. I find that very sad, but it seems that most senior professional programmes and senior forum members seem to have mental problems)

Note I have seen many professionals warn against using Send Keys since they say it can be unstable and lead to some nasty crashes. But I use Send keys also ( to automate opening the VB Editor and from that the Immediate window) and so far I have not experienced any problems.

( If the solution works well for you then that might give you some new ideas for your Horizontal Tree structure idea )

( I would love to understand how Peter’s macro works, as I would like to learn more about Send Keys. Unfortunately there are so many things to learn about VBA that there is not enough time in a life time. ( Many people who will give you many great codings are strangely reluctant to explain them… ) )