Create a dropdown that affects another dropdown?

MikeyW1969

Board Regular
Joined
Apr 28, 2014
Messages
80
Hey all, I am trying to create a new hire submission form, because our current system sucks.

I want to create a form that starts with a dropdown. Based on the choice in that dropdown (Title/Position), I would like certain other fields to populate. For example, a Sales Specialist would get an Office 'E3' license, and would have certain CRM responsibilities. Other positions would have the Office 'E1' license, and might have only the single default CRM responsibility. There would be a few more. I'm hoping to automate this hiring process so that we can focus on other roadblocks in our onboarding procedures.

I originally wanted to do this in Acrobat as a form, but the search results are ridiculously dated. The most referred to article ifs from 2006, and half of the tools they call out are named differently, located somewhere else, or just don't exist anymore Is this something that I could create in Excel, using VBA, or something? And can it then be exported as an Adobe Form?

I'm more interested in making this work than what software application it lives in, so if Excel is the second best choice, but the one where I get it to work, that's cool by me. :)

As always, any help is greatly appreciated. I'm hoping that I phrased this correctly.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Nothing you create in Excel can be exported to PDF as an interactive PDF form - all that will be exported to the PDF is static content reflecting whatever was displayed in Excel at the time.
 
Upvote 0

Forum statistics

Threads
1,215,019
Messages
6,122,707
Members
449,093
Latest member
Mnur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top