ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ²M³æ¶µ¥Ø¦p¦ó«Ø¸m

[µo°Ý] ²M³æ¶µ¥Ø¦p¦ó«Ø¸m

¤p§Ì³Ìªñ·Q¤O¥ÎLISTBOX©ÎCOMBOX«Ø¸m²M³æ
®Ñ¤¤½d¨Ò¦p¤U(¦³³¡¥÷¬Ù²¤):
MSGBOX "«Ø¸m¶µ¥Ø"
WITH ACTIVESHEET.LISTBOX1.ADDITEM "¤À¤½¥q  A"
END WITH

¦ý¤p§Ì°õ¦æF5®É,¨Ã¨S¦³¥X²{¶µ¥Ø???

¥i§_À°¤p§Ì¸Ñ´b,·PÁÂ

¦^´_ 1# rph
  1. Sub Ex()
  2.    ActiveSheet.ListBox1.AddItem "¤À¤½¥q  A"
  3.    '''''''''  ¦P¤U    '''''''''''''''''''''
  4.    With ActiveSheet.ListBox1
  5.         .AddItem "¤À¤½¥q  b"
  6.     End With
  7. End Sub
½Æ»s¥N½X

TOP

©_©Ç ~~
¬°¤°»ò§Ú¸ÕÁÙ¬O¨S¦³???
Private Sub ListBox1_Click()
ActiveSheet.ListBox1.AddItem "¤À¤½¥q  A"
With ActiveSheet.ListBox1
    .AddItem "¤À¤½¥q a"
End With
End Sub

TOP

AddItem¥²¶·¥ý¦³²M°£ªº°Ê§@
§_«h·|¥[¤J¤@°ï¬Û¦Pªº§Ç¦C
¸û«Øijªº§@ªk¬O¡G
Private Sub ListBox1_GotFocus()
A = Array("A", "B", "C", "D", "E")
ActiveSheet.ListBox1.List = A
End Sub

TOP

¦^´_ 1# rph


    ¼Ó¥Dªº¥Î·N~ À³¸Ó­n§ó²M·¡ªº»¡©ú·|¸û¦n­ò~
    ¬Ý°_¨Ó¤@¶}©lªº¤å·N~ À³¸Ó¬O
   1. «ö¤UBUTTOM
     2.¶]¥X¤@­Ó¥i«Ø¸m¸ê®Æ¦bLISTBOXªº¿é¤Jµøµ¡,¥i¥ÎINPUTBOX ©Î¬O³]­p¤@­Óªí³æ¤è¦¡¨Ó³B²z
   3.±N¿é¤Jªº¸ê®Æ~·s¼W¦bLISTBOX¤¤  (­n¦Ò¶q¬O§_¬°­«Âиê®Æ,­Y¬O­«Âиê®Æ³o¤£«Ø¤J,§_«h«h«Ø¤J)
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦^´_ 5# hugh0620
¦pªG¬O³o¼Ë¡A¸Õ¸Õ
  1. Private Sub CommandButton1_Click()
  2. Set d = CreateObject("Scripting.Dictionary")
  3. n = InputBox("½Ð¿é¤J²M³æ¶µ¥Ø", , "ItemA")
  4. Do Until n = ""
  5.    If d.exists(n) = False Then ComboBox1.AddItem n
  6.    d(n) = d.Count
  7.    n = InputBox("½Ð¿é¤J²M³æ¶µ¥Ø", , "ItemB")
  8. Loop
  9. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦b³oÃä¨Ç·PÁ¤j®aªº«ü¾É!³y¦¨¤j®a§xÂZ,ÁٽХ]²[!
§Ú¶¶«K¦A­«·s»¡©ú¤@¤U§Úªº°ÝÃD!!
1.§Ú¦Û­qªí³æ«á,¦bªí³æ¤W«Ø¤FLISTBOX1
2.±µ¤U¨Ó§Ú¼g¤F«Ø¥ß²M³æªºµ{¦¡½X,«ö¤UF5°õ¦æ,¤£¹L¦b§ÚªºLISTBOX¤¤,¨Ã¨S¦³¥X²{§Ú©Ò°µªº²M³æ¶µ¥Ø
3.µ{¦¡½X¦p¤U
Private Sub ListBox1_Click()
ActiveSheet.ListBox1.AddItem "¤À¤½¥q  A"
With ActiveSheet.ListBox1
    .AddItem "¤À¤½¥q A"
End With
End Sub

TOP

¦^´_ 7# rph


    ¼Ó¥D­n¤£­n§â°µªº¤W¶Ç¤W¨Ó~ ³o¼Ë¤ñ¸û²³æ³B²z~
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

§Ú¦Û­qªí³æ«á,¦bªí³æ¤W«Ø¤FLISTBOX1
¤S«ç·|¬O
ActiveSheet.ListBox1.AddItem "¤À¤½¥q  A"
With ActiveSheet.ListBox1
ListBox1¨ì©³¦buserfoum¤¤ÁÙ¬O¤u§@ªí¤WªºOLEObject¡H

TOP

¦^´_hugh0620
§Ú°µªºªF¦è,´N¬O³o¼Ë!(p.s§Ú·Óªº®Ñ¥»½d¨Ò§Ëªº)
Private Sub ListBox1_Click()
ActiveSheet.ListBox1.AddItem "¤À¤½¥q  A"
With ActiveSheet.ListBox1
    .AddItem "¤À¤½¥q A"
End With
End Sub

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD