Excel 2010 Open another form based on a drop down

I have an excel 2010 form that I created which is very simple by design. In one section of the form I have a drop down based on a question on the form. The drop down contains yes or no. What I am wondering is if the user selects yes, is there a way to open another form automatically that is on a shared drive on my network and if so how do I acomplish this?
tmaususerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Yes you can, in Design mode on the Form, right click on the drop down input item and choose View Code. This will give you a code snippet to amend for when a value is selected.

I assume this will open another User Form from the same file, not sure what you are getting at with "another form on a shared drive".

Thanks
Rob H
0
 
tmaususerAuthor Commented:
Sorry If I was not clear enough. I don't know the code to make this other form open based on if yes is selected. How do I do that????
0
 
Rob HensonFinance AnalystCommented:
Can I clarify your terminology for what you mean by a form?

Option 1 - User Form created in VB Project with various types of Input. Gets activated by a VBA routine.
Option 2 - Worksheet used as an input sheet with headers and input cells, with dropdown or validation options.

By form on a shared drive, do you mean it will open another file with another worksheet with input options?

Thanks
Rob H
0
 
tmaususerAuthor Commented:
Rob,

My form is based on your option two. I have attached a sample for your review which may give a better understading. In cell E43 is where the user answer's yes or no. It is in this cell that if the user answers "Yes" a seperate form on my share will open. My thought was something like If combo1 = yes then docmd open "share\folder\drawing.doc or something along those lines since I don't code. You can also see I unhide colums as I have some conditional formatting. Hope that clears things up.
Sample.xlsm
0
All Courses

From novice to tech pro — start learning today.