Solved

Excel 2010 Open another form based on a drop down

Posted on 2014-10-21
4
122 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 31

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 31

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
My experience with Windows 10 over a one year period and suggestions for smooth operation
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

706 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now