ªð¦^¦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 : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD