Excel VBA (part 2): UserForm to Select Item from Dropdown List

Описание

In this video I demonstrate the steps on how to create a listbox userform by Visual basic for dependent dropdown list.
In previous video we have created two dropdown list in the excel template. By selecting regions and account we found that dropdown list selection window is too small with limited visible rows when scroll the long account list. To improve the user experience we have applied one method: vba userform listbox.


Other References Links
Using Option Explicit forces you to declare all your variables:
https://excelmacromastery.com/vba-userform/

Validation.Formula1 property (Excel) | Microsoft Docs:
https://docs.microsoft.com/en-us/office/vba/api/excel.validation.formula1

XlDVType enumeration (Excel) | Microsoft Docs:
https://docs.microsoft.com/en-us/office/vba/api/excel.xldvtype

Application.EnableEvents property (Excel) | Microsoft Docs:
https://docs.microsoft.com/en-us/office/vba/api/excel.application.enableevents

Close form by Unload Me:
https://www.automateexcel.com/vba/open-close-userform/#Close_a_Userform_using_VBA

The Initialize event is typically used to prepare an application or UserForm for use:
https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/initialize-event
The Initialize event occurs when a userform is first loaded into memory

For more info of my BI & Analytics, please refer to the following website links:

My BI & Analytics Website:
https://sites.google.com/view/mikeguangyuanyu/blog-pages/bi-analytics-and-automations

My blog website :
https://mikeyu.lovestoblog.com/