且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Excel在工作表中过滤并在“用户窗体"列表框中填充过滤范围

更新时间:2023-12-01 10:36:04

如果找到了一种解决方法.

If found a way to do this.

我使用转到特殊内容"仅可见单元格",我选择了结果,然后将这些值复制到另一张纸上. 我将这些步骤记录为一个宏.

I use "Go to special" "Visible cells only" i select my results, copy those value in another sheet. I recorded those steps as a macro.

毕竟,我像其他列表框一样填充列表框.

And after all that i populate my listbox like any other listbox.