ªð¦^¦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°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD