Solved

Excel 2010 Open another form based on a drop down

Posted on 2014-10-21
4
126 Views
Last Modified: 2014-11-06
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?
0
Comment
Question by:tmaususer
  • 2
  • 2
4 Comments
 
LVL 32

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 40394763
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
 

Author Comment

by:tmaususer
ID: 40394820
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
 
LVL 32

Expert Comment

by:Rob Henson
ID: 40395004
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
 

Author Comment

by:tmaususer
ID: 40395145
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

Featured Post

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question