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

½Ð±Ð¤@¬qµ{¦¡, ¸Ó¦p¦ó¼g,

½Ð±Ð¤@¬qµ{¦¡, ¸Ó¦p¦ó¼g,

«e½ú­Ì, ½Ð±Ð¤@¬qµ{¦¡, ¸Ó¦p¦ó¼g, ½Ð°Ñ·Ó¹Ï¤ù»¡©ú,
¥ý¦æÁÂÁÂ!!

¦^´_ 1# ©P¤j°¶

¤ñ¸û²©öªº¤è¦¡¦p¤U
  1. Private Sub UserForm_Initialize()
  2. arr = Sheets("¤u§@ªí2").Range("a1:a" & Cells(Rows.Count, 1).End(xlUp).Row)
  3. ComboBox1.List = arr
  4. End Sub
½Æ»s¥N½X

TOP

¦^´_ 2# lpk187
ÁÂÁ¤j¤j, ¯¬§Ö¼Ö

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD