Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2021, 01:34 AM
john_red's Avatar
john_red john_red is offline Excel Dependent Drop Down Lists Windows 7 64bit Excel Dependent Drop Down Lists Office 2010
Novice
Excel Dependent Drop Down Lists
 
Join Date: Jan 2020
Location: Alabama
Posts: 2
john_red is on a distinguished road
Default Excel Dependent Drop Down Lists

Hi,
I created a template with dependent drop down lists.I hope it will be useful for users.
The database includes products, product categories, suppliers of products and prices. Even if the data in the table is mixed, we can comfortably examine the products by grouping them by category and suppliers on linked drop-down lists , the data can be entered to other sheets.





Source
Attached Files
File Type: xlsm dependent_combo_boxes.xlsm (37.9 KB, 19 views)
Reply With Quote
  #2  
Old 02-13-2021, 11:08 AM
Logit Logit is offline Excel Dependent Drop Down Lists Windows 10 Excel Dependent Drop Down Lists Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Very nice work.

Thank you.
Reply With Quote
  #3  
Old 02-15-2021, 06:51 AM
Marcia's Avatar
Marcia Marcia is offline Excel Dependent Drop Down Lists Windows 7 32bit Excel Dependent Drop Down Lists Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you for sharing this. I will try this in my database that contains lots of account codes and account names. I will get back should I come across any problem.
Nothing is shared because the code is hidden. Nice try...

Last edited by Marcia; 02-16-2021 at 05:51 AM.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Absolute Dependent Dropdown lists probinson76 Word VBA 5 06-07-2020 03:59 PM
Excel Dependent Drop Down Lists Drop-down menu in Excel, filling up the lists according to selection blackarrow Excel 18 01-18-2017 08:04 AM
Dependent drop down lists bobbych Word 1 02-08-2013 04:38 PM
Excel Dependent Drop Down Lists Drop-down lists in Excel Maureen Excel 1 11-10-2011 08:11 AM
Dependent drop down lists in Word 2007 benbenasc Word VBA 0 08-24-2011 06:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft