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

½Ð±Ð¦Û°ÊIJ°Êvba»yªk°ÝÃD

½Ð±Ð¦Û°ÊIJ°Êvba»yªk°ÝÃD

Dear ¤j¤j,

¤§«e¦³¸Õ¹L¦bJ2Äæ¦ì¡A¥u­n¦³Ä²°Ê(½s¿è¹L)J2¡AVBA¦Û°Ê·|°õ¦æ(»yªk¦p¤U)

¦ý§Ú²{¦b¨ÃµLIJ°Ê¡A¦Ó¬O¦bexcel¤u§@ªí¤W(¥kÁä-¿ï¾Ü©Ê¶K¤W-­È)¡A¤£ª¾¹D¦³°µ³o°Ê§@¡AVBA¬O§_¤@¼Ë¥i¥H¦Û°Ê°õ¦æ¡H


Private Sub worksheet_change(ByVal target As Range)

  If target.Address = "$J$2" Then
     Call ·s¼W¹Ïªí¸ê®Æ
     Call ·s¼W¹Ïªí¸ê®Æ2

  End If

End Sub
Just do it.

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD