Forum Discussion
Solved
Using conditional formatting or VBA to automatically open the next drop down menu after selecting ?
I am trying to streamline a report format to make it more usable: it has a list of questions followed by a drop down menu - example attached. After selecting an item in the current drop down I would ...
I am a rank amateur with Excel. I can find my way around the basics but VBA is still a bit of black magic. I received the attached error message and haven't gone further with it to avoid making errors. Advice?
That means you are using 64 bit of Excel. I am using 32 bit of Excel.
Please find the attached and let me know if that works without producing an error on your end.
No sir. I still get an error message. Your first example had two sets of code. One seemed error free. (Actually there is a compiler error - Private Sub Worksheet_SelectionChange(ByVal Target As Range) Please elucidate?
I forgot to tweak something. Please check the attached and see if this works now.
Actually since I am using 32 bit version, it works on my end.
