Drop down box list based on response to another drop down box

		Microsoft Office Forums > Microsoft Excel > Excel
Drop down box list based on response to another drop down box

FAQ

Thread Tools

Display Modes

04-11-2018, 08:49 AM

NoSparks

Windows 7 64bit Drop down box list based on response to another drop down box

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

I would use VBA in the WorkSheet_Change event for this.

Right click the sheet tab and select View Code.
Hopefully I've commented things enough for you to follow.

PS: are you actually using Excel 2003 ?

Attached Files

Forum example_v2.xls (40.5 KB, 15 views)

Tags

conditional, drop down list

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import list from Excel into drop-down list into word	ahw	Word VBA	43	02-28-2020 08:11 PM
Drop down lists and pulling data from worksheet based on drop down selection	cjoyce73	Excel	5	07-17-2017 07:40 AM
how to make sections hidden/appear based on selection in Cont. Ctrl. Drop-down list	Irimi-Ai	Word	5	04-25-2017 09:31 AM
Use different sumifs based on value in drop down.	Prondr	Excel	3	12-20-2016 07:05 AM
Dynamically changing drop-down list based on selection? (Word Form)	laurarem	Word	1	02-21-2013 10:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:52 AM.