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

[µo°Ý] ¤£¥ÎVBA, ¦p¦ó§Ö³t¿ï©w©Ò¦³ªºRadio Button?

[µo°Ý] ¤£¥ÎVBA, ¦p¦ó§Ö³t¿ï©w©Ò¦³ªºRadio Button?

¤£¥ÎVBA, ¦p¦ó§Ö³t¿ï©w©Ò¦³ªºRadio Button? ³o¨Çradio¥i¯à¤À§G¦b¤u§@ªíªº¥ô¦ó¦a¤è.

ÁÂÁÂ
Radio button.rar (12.54 KB)
ss

¦^´_ 1# sunnyso


   
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 2# GBKEE

·PÁ¶Wª©, ½Ð°ÝExcel 2010 ¦b­þùاä?

ÁÙ¦³Word ¤]¦³Ãþ¦üªº¤èªk¶Ü?

ÁÂ
ss

TOP

¦^´_ 3# sunnyso
¶·½Ð¦³ Excel 2010 ªº¨Ó¸Ñµª
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 3# sunnyso


  §ä¤£¨ìªº¸Üª½±µ«öCTRL+G¸Õ¸Õ

TOP

¦^´_ 3# sunnyso

play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh

·PÁ¶Wª©©M¦U¦ì¼ö¤ß¤j¤jªº¸Ñ»¡,

ÁÙ¦³¤@­Ó°ÝÃD, ¬O§_¥i¥u¿ï©w¯S©wªºobject ¨Ò¦p¥u¿ï©w radio button ¦Ó¤£¿ï©w checkbox ©O?
ss

TOP

¦^´_ 7# sunnyso
­n¥ÎVBA
  1. Option Explicit
  2. Sub Ex()
  3.     Dim s As Shape, M(), i As Integer
  4.     For Each s In ActiveSheet.Shapes
  5.         If s.FormControlType = xlOptionButton Then
  6.             ReDim Preserve M(i)
  7.             M(i) = s.Name
  8.             i = i + 1
  9.         End If
  10.     Next
  11.     ActiveSheet.Shapes.Range(M).Select
  12. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 8# GBKEE


  ·PÁÂ:handshake
ss

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD