vba多重下拉选单

楼主: fbpc (HAC)   2022-08-10 13:30:29
请问各位大大,想自订表单内,要设定三个下拉选单(分别为单位、职务、姓名)目前写一
个,其它都不能用
Private Sub UserForm_Initialize()
For I=2 To Sheets(“首页”).Range(“A1”).End(xlDown).Row
单位1.add item cells(I,”A”)
https://i.imgur.com/0lkEG65.jpg
https://i.imgur.com/0lkEG65.jpg

Links booklink

Contact Us: admin [ a t ] ucptt.com