[µo°Ý] Ãö©ómsgboxªº¥Îªk

§Ú¬OÞ±

§Úªº¤u§@ªí¤W¦³³]¤@­Óªí³æ²M°£ªº©R¥O¦¡«ö¶s
µ{¦¡¤º®e:
Sub ªí³æ²M°£()
Dim Y&
With Sheets("³øªí")
  Y = .[A65536].End(xlUp).Row - 2
  .Range("A3:R" & Y).ClearContents
End With
With Sheets("½Ð´Ú³æ")
  .Range("a:h").Clear
End With
End Sub
§Ú·Q­n³]·í³o«ö¶s«ö¤U·|¸õ¥Xµøµ¡°Ý¬O§_¤w¥t¦s·sÄÒ¤F?¬O!´N°õ¦æ²M°£ªºµ{¦¡¤º®e,§_´N¸õ¦^¤u§@ªí!
ª¦¤å ¬O¥Îmsgbox,¦ý§Ú¤£ª¾¹DÀ³¸Ó¼g¦b«ö¶s¤ºÁÙ¬O¤u§@ªí¤º
¨º¤S¸Ó¦p¦ó¼g?¥Îªkºô¸ô¤W­±³£¦³¦ý¬O¤£ª¾¹D¸Ó¦p¦ó±a¤J?

Hsieh

¦^´_ 1# §Ú¬OÞ±

1. Sub ªí³æ²M°£()
   
2. Dim Y&
   
3. yn = MsgBox("¬O§_¤w¸g¥t¦s·sÀÉ", vbYesNo)
   
4. If yn = 7 Then MsgBox "½Ð¥t¦s·sÀÉ«á­«·s°õ¦æ«ö¶s": Exit Sub
   
5. With Sheets("³øªí")
   
6.   Y = .[A65536].End(xlUp).Row - 2
   
7.   .Range("A3:R" & Y).ClearContents
   
8. End With
   
9. With Sheets("½Ð´Ú³æ")
   
10.   .Range("a:h").Clear
    
11. End With
    
12. End Sub

½Æ»s¥N½X