?
Solved

Excel 2010 Open another form based on a drop down

Posted on 2014-10-21
4
Medium Priority
?
131 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 33

Accepted Solution

by:
Rob Henson earned 1500 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

764 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