½Ð±ÐUserForm±a¤J¤Þ¼Æ»P±a¥X¤Þ¼Æªº°ÝÃD
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 1# clio
³q±`©I¥sªí³æ´N¬O¦b¤@¯ë¼Ò²Õ©I¥s
Load Userform1
©M
Userform1.Show
¦pªGn¶Ç¤@¨Çªì©l¤Æªº¸ê®Æµ¹ªí³æ¡A¥i¦bªí³æµ{¦¡½X·s¼W¦pSub InitForm(arInput)- Public Sub InitForm(arInput)
- ListBox1.List = arInput
- End Sub
½Æ»s¥N½X ¤@¯ë¼Ò²ÕShow¤§«e©I¥sInitForm¶Ç»¼µ¹ªí³æ- Sub Test()
- Dim ar
- ar = Array("A", "B", "C")
-
- Load UserForm2
- UserForm2.InitForm ar
- UserForm2.Show
- End Sub
½Æ»s¥N½X Userform «ö¶s«á¨ú±o¤w¿ï¶µ¥Ø- Private Sub CommandButton1_Click()
- Dim Output_AR(1 To ListBox1.Count)
- Dim i As Integer, cnt As Integer
-
- For i = 1 To ListBox1.ListCount
- If ListBox1.Selected(i) Then
- cnt = cnt + 1
- Output_AR(cnt) = ListBox1.List(i)
- End If
- Next
- If cnt > 0 Then
- ReDim Preserve Output_AR(1 To cnt)
- '¦Ü¦¹ Output_AR ¤w¨ú±o¿ï¾Üªº¶µ¥Ø
- End If
- End Sub
½Æ»s¥N½X |
|
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 3# clio
§Aªº·N«ä¬O·Q¦A§âOutput_AR¶Ç¦^Test¤º?
³q±`§Ú¬O¤£·|¦A¶Ç¦^Test°Õ¡A¬JµM§Ú¤w¸g¦³Output_AR¡A¦pªG§Ún°µ¬Æ»ò¤ÀªR©Î³B²z¡A´N¦bClick¤º©I¥s§Ún³B²zªºFunction ¨Ã§âOutput_AR¶Ç¨ì§Ún³B²zªºFunction¤º¤£´N¦n¤F?
°í«ùn¶Ç¦^Testªº¸Ü¡A´N¦b¤@¯ë¼Ò²Õ«Å§i¤@Ó¼Ò²Õ¼h¦¸ªº¤½¥Î(Public)ÅܼơA«e±ªºOutput_AR³£§ï¦¨ª½±µ¥Î³oÓ¤½¥ÎÅܼơA³o¼ËTest¤º¤]¯à¬Ý¨ì³oÓÅܼƴN¤£¥Î¶Ç¤F¡C
¤£¹L¡A§An¥ýª`·Nªº¬O¹w³]ªºªí³æ¡A·í§A©I¥sUserForm2.Show«á¡Aªí³æÅã¥Ü¥X¨Ó¡Aµ{¦¡·|°±¯d¦b¸Ó¦æ¡A·|¤@ª½µ¥¨ìªí³æÃö³¬¤~·|¸õ¨ì¤U¤@¦æ¡C
°Ýªº¤£°÷©ú½T§Ú¤]¥u¯à³o¼Ë¦^µª°Õ¡C |
|
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C
|
|
|
|
|