Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Dropdown list in cell vba

0

How to make dropdown list when user select one list in cell, the next cell will display related data in drop down list.

For instance, I make cell A2 contain dropdown list such as Japan, Korea, Thailand. Next cell B2 has list such as Tokyo, Osaka, Busan, Seoul, Phuket, Krabi.

When user select in cell A2 Korea and move to next cell B2, it only show dropdown list Busan and Seoul. If user select Japan in cell A2 it will show dropdown list Tokyo, Osaka in cell B2.

How to do it and is it possible to make it? Is there any source I can refer?

excel
MS Office Version: 2019
posted by: kimurios (rep: 2) on Tue Feb 21, 2023 at 1:36 am
Answer
Discuss

Discussion

Kimurios. Did you try the tutorial I suggested (in my Answer)? 
John_Ru (rep: 6142) Feb 23, '23 at 5:27 pm
Add to Discussion

Answers

0

Hi Kimurios. 

This doesn't need VBA and is covered in Don's tutorial here: Automatically Updating Dependent Drop Down List Menus in Excel

posted by: John_Ru (rep: 6142) on Tue Feb 21, 2023 at 2:37 am
Discuss

Discussion

Kimurios. Did you try the tutorial I suggested (in my Answer)?
John_Ru (rep: 6142) Mar 6, '23 at 4:31 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login