Solved

Excel 2010 Open another form based on a drop down

Posted on 2014-10-21
4
127 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 33

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 33

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

My experience with Windows 10 over a one year period and suggestions for smooth operation
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

837 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