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

­­¨î¿é¤J¸ê®Æ¬O¤é´Á®æ¦¡

­­¨î¿é¤J¸ê®Æ¬O¤é´Á®æ¦¡

¥»©«³Ì«á¥Ñ enoch ©ó 2012-6-25 12:59 ½s¿è

½Ð°Ý¦p¦ó§Q¥ÎINPUTBOX ­­¨î¿é¤Jªº¸ê®Æ¥²»Ý¬O¤é´Á,
¦Ó¥B³]©w®æ¦¡¬O "DD/MM/YYYY"

¥t¥~·í¥ÎDIM ®É, ®æ¦¡·|¦Û°Ê³]©w¬°MM/DD/YYYY À³¦p¦ó­×§ï

¿é¤J¤é´Á¬O¥Î§@¿z¿ï©Ò¦³¤j©ó«ü©w¤é´Áªº¸ê®Æ

½Ð«ü±Ð

¦^´_ 1# enoch
  1. Sub Test()
  2.     Dim str
  3.     Do Until IsDate(str)
  4.       str = InputBox("½Ð¿é¤J¤é´Á¡G", "¤é´Á")
  5.     Loop
  6.     [A1] = str
  7.     [A1].NumberFormat = "dd-mm-yyyy"
  8. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD