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

°j°é¯Ó®Éªº°ÝÃD

°j°é¥»¨­¦¸¼Æ¦h¡A¦³®É¤]·|ºC¡A¤×¨ä¬O¹ï¶H¬OÀx¦s®æ¡C
¦³¨Çª¬ªp¥i¥H¤£¥Î°j°é¡Aª½±µ¹ï¾ã­Ó½d³ò´M§ä¨ú¥N¡AÀ³¸Ó·|¤ñ¸û§Ö¡C
IIf¥»¨­¤ñ¸ûºC¡A¦³®É­Ôµ{¦¡½X¸û²²¤¡A¬Û¹ï°õ¦æ®Ä²v¤Ï¦Ó¸û§C¡A§âµ{¦¡½X¼gªø¤@ÂI¡A
Rng.Interior.ColorIndex = IIf(i = 44, 38, IIf(i = 4, 40, IIf(i = 8, 39, i)))
¦¹¦æ®i¶}¡G
if .....then
elseif ...... then
else
end if
©Î¥ÎSelect Case»y¥y¤]¦æ¡A
³o¼Ëªº«¬¦¡®Ä²vÀ³¸Ó¤ñ¸û¦n¡C
Word§e²{·¥­PªºÀRºA¤§¬ü¡AExcel®i²{·¥­Pªº°ÊºA¤§¬ü¡C

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD