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

°ÝÃD½Ð±Ð

°ÝÃD½Ð±Ð

½Ð±Ð¦U¦ì¤j¤j&°ª¤â

               ¬°¦ó¥Î¤u§@ªí "C"Ä檺­È¬d¸ß,¤u§@ªí2µLªkÅã¥ÜAÄæ¤ÎBÄ檺¸ê®Æ,¥BListbox1¤]µLªkÅã¥Ü,½Ð¨ó§U ÁÂÁ listbox.zip (33.31 KB)
yvonne

¦^´_ 3# jcchiang


    j¤j·PÁÂ~~~
yvonne

TOP

¦^´_ 2# afu9240
ListBox1.List(i, j) = a.Offset(, (j - 2))
Worksheets("¤u§@ªí2").Cells(i + 1, j + 1) = a.Offset(, (j - 2))

TOP

¬°¦ó¤u§@ªí1 "c"Ä檺­È°µ¬d¸ß   ¤u§@ªí2¤Îlistbox1µLªkÅã¥Ü¤u§@ªí1 "A"Äæ¤Î"B"Ä檺­È
yvonne

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD