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

[µo°Ý] ¦p¦ó§Ö³tÅÜ´«Workbook_Openªº¨âºØ¥\¯à»Ý¨D?

[µo°Ý] ¦p¦ó§Ö³tÅÜ´«Workbook_Openªº¨âºØ¥\¯à»Ý¨D?

¥»©«³Ì«á¥Ñ av8d ©ó 2012-7-3 09:11 ½s¿è

Private Sub Workbook_Open()
    Range ("A1")
End Sub

Private Sub Workbook_Open()
    Range ("Z1")
End Sub

¥H¤W¬°½d¨Ò~¬O§_¦³¤°»ò¤èªk¥i¥H§Ö³tÅÜ´«Workbook_Open¤ºµ{¦¡½Xªº¤º®e?
¨Ò¦p§Ú»s§@¨â­ÓOptionButton¡A¤À§O©R¦W¬°A1©MZ1
·íÂI¨ìA1ªº®É­ÔWorkbook_Open´NÂà´«¦¨A1
·íÂI¨ìZ1ªº®É­ÔWorkbook_Open´NÂà´«¦¨Z1

¥»©«³Ì«á¥Ñ av8d ©ó 2012-7-3 22:09 ½s¿è

¦^´_ 2# GBKEE

¥H¤U³£¬OActiveX±±¨î¶µ:

¦pªG§ï¦¨
·í¿ï¨úOptionButton1°µ
Private Sub CommandButton10_Click()
Range("A1")
End Sub
·í¿ï¨úOptionButton2°µ
Private Sub CommandButton10_Click()
Range("Z1")
End Sub

¤]¾A¥Î¤j¤j´£¨Ñªº¤èªk®M¥Î¶Ü?
·í¿ï¨úOptionButton1Ãö³¬ÀɮצA¶}±Ò
¥L·|²¾°Ê¨ìA1
·í¿ï¨úOptionButton2Ãö³¬ÀɮצA¶}±Ò
¥L·|²¾°Ê¨ìZ1

¨¯­W¤j¤j¤F~ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD