VBA¬O§_¥i¥H«Ø¥ß°ÊºAUserForm
- ©«¤l
- 132
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2024-2-28
|
¬Ý¤F¡A¦ý¬O¤´µM¦³¨Ç°ÝÃD¡A¹³Excel§Ú¥Î
Set mynewform = Application.VBE.ActiveVBProject.VBComponents.Add(vbext_ct_MSForm)
¦ý¬O·|¥X²{¥¢±Ñ»¡¡A¤£ª¾¹Dn§ï¤°»ò |
|
clio
|
|
|
|
|
- ©«¤l
- 319
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 309
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2k
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-6-24
- ³Ì«áµn¿ý
- 2024-4-27
|
«Øij¤j¤j UserForm ¤£n¥Î°ÊºA
Set FC = Application.VBE.ActiveVBProject.VBComponents.Add(3)
Set F = UserForms.Add(FC.Name)
F.Show 0
Set TextBox = F.Controls.Add("forms.TextBox.1")
TextBox.Top = 0
Set ListBox = F.Controls.Add("forms.ListBox.1")
ListBox.Top = 30
MsgBox "Stop"
Application.VBE.ActiveVBProject.VBComponents.Remove FC |
|
|
|
|
|
|
- ©«¤l
- 2834
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2890
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-26
|
¥»©«³Ì«á¥Ñ ã´£³¡ªL ©ó 2016-3-17 10:06 ½s¿è
°£«D±M·~, °ÊºAªí³æ¤Îª«¥ó¼W§R, ¹ï·s¤â¬O°ªÃø«×, ¦Ñ¤â¤£¥²µM¥i¥H§¹¥þ´x´¤,
¦pªGÁÙnÅý·s¼Wª«¥ó¦³Ä²µo¨Æ¥óµ{¦¡, ´N§ó½ÆÂø,
§Úªº¤è¦¡¬O¹w³]¥²nª«¥ó, ¦A¥Hµ{¦¡¥h¨M©wþ¨Çª«¥óÅã¥Ü»P§_,
¦Ü©óCHECKBOXªº¥\¯à, ¦³®É¥ÎLISTBOXªº¦h«¿ï¾Ü¤]¥i¹F¨ì¥Øªº,
¤£¹Lªí³æªº³]p¤£ºâ³æ¯Â, ¹ï·s¤â¨Ã¤£®e©ö, ³Ì¦n¥h¶R¥»±Mªù¤¶²Ðªí³æªº®Ñ¬Ý,
¦³°ò¦¤~¯à¥h¹B¥Î¦U¶µ§Þ¥©~~~ |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2024-2-28
|
¦^´_ 11# jackyq
·PÁ¤j¤jªº¦^ÂСG
§Ú¦n¹³¦b²Ä¤@¦æ´N·|¥d¦í¡AµLªk°õ¦æªº¹L¥h»¡¡A¤j¤jªº¤]·|³o¼Ë¤l¶Ü¡H
·PÁ¤j¤jªº´£¿ô¡A§Ú·|Å¥±q±zªº«Øij¡AUserForm¤£¨Ï¥Î°ÊºAªº¡A¦]¬°³oÃ䦳¨ÇIJµoÂI¡A¤£¦n³B²z¡A¥u¬O·|·Qª¾¹D«ç»ò¼Ë¥i¥H°ÊºA«Ø¥ßUserForm¥u¬O¦n©_¡A·Q»¡¥i¥H¦h¾Ç¤@¼Ë¦Ó¤w |
|
clio
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2024-2-28
|
¦^´_ 12# ã´£³¡ªL
·PÁÂã´£³¡ªL¤j¤jªº¦^ÂÐ
½T¹ê¦p¦P¤j¤j©Ò»¡¡A³o¤G¤Ñ¬ã¨sªº¹Lµ{¤¤¡A¦³¸Õ¹L°ÊºA«Ø¥ßControl¡A©Ò¥H¤]¦n©_¬O§_¯à°ÊºA«Ø¥ßUserForm¡A¦ý¬O¤]¦p¦P¤j¤j©Ò»¡¡Aª«¥óªºÄ²µo¡A³oÓˬO¤@Ó¤j¤jªº°ÝÃD
·|±µ¨üã¤jªº«Øij¡A§â¤@¨Ç¥i¯à·|¥Î¨ìªº¹w³]¦bUserForm¤º¡A¦A¨Ìµ{¦¡¥N¤Jªº°Ñ¼Æ¡A¨Ó¨M©w¨º¨ÇnÅã¥Ü¡A³oÓ½T¹ê¤]¬O§Ú¦Ò¼{¹Lªº¤èªk¤§¤@¡A¥u¬O¹ï©ó³o¤è±ªº¬ã¨sÁÙ¯uªº¬O¦³®É·|·Qª¾¹D
¦³¨S¦³¾÷·|³o¼Ë§@¡H¤~·|¤S°Ý¤F°ÊºAUserFormªº°ÝÃD¡A§Ú¤]¦³¥hŪ®ÑÀ]¬d¤F¤@¨Ç®Ñ¡A¦ý¬O¹ï©óVBA¸ÔºÉªº¦n¹³¨S¦³¨£¨ì¡A¤£ª¾¹Dã´£³¡ªL¤j¤j¦³¨S¦³«Øijªº®ÑÄy¡A¥i¥HÅý§Ú¥h¶R¦^¨Ó°Ñ¦Òªº¡A·PÁ±z¡C |
|
clio
|
|
|
|
|
- ©«¤l
- 2834
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2890
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-26
|
¦^´_ 14# clio
¨S¿ìªk´£¨Ñ¦³þ¨Ç®ÑÄyªº°Ñ¦Ò, «Øij¥h®Ñ§½§ä, ³o¬O¤u¨ã®Ñ, ¥i¦h¶R´X¥»,
°£¤Fªí³æÀ³¥Î, VBA³Ì°ò¦ªº®Ñ¤]¥²³Æ, ©ñ¦b¤âÃä, ¹J°ÝÃD´N¥h½, §ä¨ì¸Ñ¨M¤èªk, ´N¾Ç¤@©Û,
Y¨S¦³°ò¦, ¥u¦b¦¹µo°Ý, ¤£¤î°Ý¤£¨ì«ÂI, §O¤Hµ¹ªºµª®×, ¤]¬O¤@ª¾¥b¸Ñ,
¥t, VBE¤º«Ø»¡©úÀɬO«D±`¦nªº¾Ç²ßºÞ¹D, ªá¨Ç®É¶¡¥h´MÄ_~~~
¾ÇVBA, §Ú¥u«Øij¥Î¡e¤TªáµP¡f--ªá®É¶¡¡Dªáºë¯«¡Aªáª÷¿ú(¶R®Ñ)¡ã¡ã¡ã§OµL¥¦³~
¦³¤F°ò¦¡A¦A¨Ó¬Ý§O¤H¼gªºµ{¦¡¡A´N¦³ÁŵM¶}®Ôªº·Pı¡A«æ¤£¨Ó¡I¡I¡I |
|
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2024-2-28
|
¦^´_ 15# ã´£³¡ªL
·PÁ¤j¤jªº¦^ÂСA§Ú¤]¬O¥Dn¬O¦b»¡©ú¤º§ä½d¨Ò¡A¾Çªº¡A³oÓ¯uªºnªá®É¶¡¡A¬ã¨s¡B´ú¸Õ¡A´N·|µo²{n»â¦b¨ºÃä¡A¾Ç²ß¹Lµ{¯uªº¬O«Ü´r§Ö¡K |
|
clio
|
|
|
|
|
- ©«¤l
- 228
- ¥DÃD
- 73
- ºëµØ
- 2
- ¿n¤À
- 333
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 10
- ³nÅ骩¥»
- Office 2000, 2019
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¹ü¤Æ¿¤
- µù¥U®É¶¡
- 2013-7-18
- ³Ì«áµn¿ý
- 2024-10-13
|
¨Æ¥ó¥Î¡uª«¥óÃþ§O¼Ò²Õ¡v³B²z¡A«Ü¤è«K¡C |
|
|
|
|
|
|
¡@¼ÊºÙ: ÀH·ÄÆ¿ºªº¦Ð¤ò ¡@ÀY»Î: [±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
- ©«¤l
- 852
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 918
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7 , XP
- ³nÅ骩¥»
- Office 2007, Office 2003,Office 2010,YoZo Office
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦t©z
- µù¥U®É¶¡
- 2011-4-8
- ³Ì«áµn¿ý
- 2024-2-21
|
¦^´_ 1# clio
1.¥i¥H°ÊºA²£¥Í¤¸¥ó¡Buserform
2.²z½×¤W¥i¥H¡A¦ý¬Ý©pn«ç§PÂ_¡A¥u¬O ¤£À´©p»¡ªº·N«ä |
|
¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~
¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk
¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM
|
|
|
|
|
- ©«¤l
- 132
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taipei
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2024-2-28
|
¦^´_ 2# mark15jill
°²¦p¡Aµ{¦¡°ÊºA²£¥Í¤@ÓUserform, ¦Ó¸Ì±¦³¤@ÓListBox¡A³o¼Ë«ç»ò°µ |
|
clio
|
|
|
|
|