Running VBA Macro based on drop down value in another sheet within workbook

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

One System to rule them all, One IDE to find them,
One Code to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
For health reasons i try to avoid reading unformatted Code

i am not sure exactly what you are trying to do so this may not suit your needs

i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

dim all variablesas required as often i have done so elsewhere in my code but only posted the relevant part

come back and mark your original post as resolved if your problem is fixed
pete

i am not sure exactly what you are trying to do so this may not suit your needs

I'm trying to have one general page, worksheet where a certain question is asked via drop down that has options, Yes or No

Based on the answer to the question to the general page, I want to then have it trigger whether another set of questions should appear via a macro on another sheet that is more product specific (basically if yes is selected on the main sheet, one set of questions would show up on another sheet, if no is answered then those questions remain hidden on the other sheet b/c they do not apply.

i am not sure exactly what you are trying to do so this may not suit your needs

I'm trying to have one general page, worksheet where a certain question is asked via drop down that has options, Yes or No

Based on the answer to the question to the general page, I want to then have it trigger whether another set of questions should appear via a macro on another sheet that is more product specific (basically if yes is selected on the main sheet, one set of questions would show up on another sheet, if no is answered then those questions remain hidden on the other sheet b/c they do not apply.

Re: Running VBA Macro based on drop down value in another sheet within workbook

is currentproductspend_hide etc procedures in another module? or what?

i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

dim all variablesas required as often i have done so elsewhere in my code but only posted the relevant part

come back and mark your original post as resolved if your problem is fixed
pete

Re: Running VBA Macro based on drop down value in another sheet within workbook

Originally Posted by westconn1

is currentproductspend_hide etc procedures in another module? or what?

I'm including it on the View Code option on the specific sheet. How do I put it in a module that is over the entire workbook? If you can steer me to some information on how to do this I think this might help me resolve the issue.

Re: Running VBA Macro based on drop down value in another sheet within workbook

in the vba editor, try add a public module that is available throughout
right click the project > add module

i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

dim all variablesas required as often i have done so elsewhere in my code but only posted the relevant part

come back and mark your original post as resolved if your problem is fixed
pete

Advertiser Disclosure:
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.