Рет қаралды 96,081
✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
📩 Tutorials in your email: www.exceleinfo....
💯 Purchase Office 365 safely in the Microsoft Store
microsoft.msaf...
In this tutorial we will see the way in which we can develop a UserForm in Excel VBA with a pair of dependent Comboboxes. When choosing a value from a first combobox, another list will be displayed in the second combobox depending on the value of the first list.
We will follow the following steps:
◾ We convert to Table the range with the values to be displayed.
◾We create a Pivot table to show the unique values and create the first list.
We use a formula to make the second list based on the value chosen from the first list.
◾ We define a name that contains the previous formula.
◾ We developed the Form.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
#MsExcel #VBA