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

[µo°Ý] °õ¦æCommandButton¦p¦óÅý©Ò¦³ToggleButton­È¬°False

¦^´_ 3# oao
  1. Option Explicit
  2. Private Sub CommandButton1_Click()
  3.     Dim E As OLEObject
  4.     For Each E In ActiveSheet.OLEObjects
  5.         If E.progID = "Forms.ToggleButton.1" Then
  6.             E.Object.Value = False
  7.         End If
  8.     Next
  9. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD