- ©«¤l
- 97
- ¥DÃD
- 32
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-3-22
- ³Ì«áµn¿ý
- 2017-8-16
|
¥»©«³Ì«á¥Ñ a703130 ©ó 2012-3-15 11:30 ½s¿è
§Ú¤w¸gª¦¤å§ä¨ì¤èªk¤F
http://forum.twbts.com/viewthrea ... ;highlight=combobox
³oÃä¤w¸g¦³§Ú»Ýnªº¤èªk
¦b Workbook ¶ñ¤J¤U±µ{¦¡½X¡A¥i¥HÅýExcel¤@¥´¶}´N¥ý°õ¦æ- Private Sub Workbook_Open()
- Call Sheets(1).ComBoxInit
- End Sub
½Æ»s¥N½X ¦b§Úªº¤u§@¶«K¦p¤U±µ{¦¡½X¡A´N¼Ë´N¯à¤@¶}¤u§@¶®É¡Acombobox´N·|¦³¸ê®Æ- Sub ComBoxInit()
- With ComboBox1
- .List = Array("½µæ", "¤ôªG")
- .Text = "²M³æ"
- End With
- End Sub
- End Sub
½Æ»s¥N½X ¤£¦n·N«ä®ö¶O½×¾Â¸ê·½ |
|