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

¤@­Ó¤ë¾äªº°ÝÃD

Private Sub Calendar1_Click()
ActiveCell = Calendar1.Value
Calendar1.Visible = False
ActiveCell.Offset(, 1).Select
End Sub

Private Sub Worksheet_SelectionChange(ByVal T As Range)
If T.Count > 2 Then End
If T.Address <> "$I$10:$J$10" Then End
Me.Calendar1.Visible = True
End Sub

TOP

­ìµ{¦¡¬O³]¸m®Ø½u»P§Aªº°ÝÃDµLÃö¡C
¤£¯à¦P®É¦s¦b¨â­ÓWorksheet_SelectionChange¨Æ¥óªº¡C

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD