• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Show/Hide Drop Down Box

Rodrigo

New Member
Hi, I have a drop down box with 3 options that a user can choose from. If the user chooses options 2 or 3, I would like, depending on the input choice, another drop down box to appear.

Can this be done with data validation as opposed to using drop down box VBA coding.

The user choices are linked to named ranges.

If the only way to do this is via VBA, please be aware that I am a complete beginner with respect to VBA.


King regards,


Rodrigo
 
Rodrigo

Have a read of these few posts on http://www.contextures.com


http://www.contextures.com/xlDataVal02.html

http://www.contextures.com/xlDataVal13.html

http://www.contextures.com/xlDataVal15.html


I Think there doing what your suggesting
 
Back
Top