|
本帖最后由 sure 于 2015-1-13 11:04 编辑
各位老师,我现在需要在combobox控件里面获取所有sheet的name的下拉列表,同时要删除Main,impedance,resistance,adjusted impedance,time和time normalized这几个sheet的name,并在获取的列表最后添加一个newplots的name,请问应该怎么写程序?谢谢,具体的可以看附件。Comobox控件在sheet4里面
- Private Sub Workbook_Open()
- Dim Sht As Worksheet, d, nm$
- Set d = CreateObject("Scripting.Dictionary")
- nm = "Main,Impedance,Resistance,Adjusted Impedance,Time,Time Normalized"
- For Each Sht In Sheets
- If InStr(nm, Sht.Name) = 0 Then d(Sht.Name) = ""
- Next
- d("newplots") = ""
- Sheet1.Combobox21.List = d.keys
- End Sub
复制代码代码放在thisworkbook的代码区里面。
|
|