Combobox dependientes en Formulario de Excel usando VBA @EXCELeINFO
95.9 هزار بار بازدید -
6 سال پیش
-
✅ Download the file |
✅ Download the file | www.exceleinfo.com/combobox-dependientes-en-formul…
🏆 Subscribe | goo.gl/M5zNA8
📩 Tutorials in your email: www.exceleinfo.com/newsletter/
💯 Purchase Office 365 safely in the Microsoft Store
microsoft.msafflnk.net/YLxXR
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/exceleinfo
Facebook Page | www.facebook.com/EXCELeINFO
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinfo.com/
#MsExcel #VBA
6 سال پیش
در تاریخ 1397/12/01 منتشر شده
است.
95,949
بـار بازدید شده