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

½Ð±Ð¦Û°Ê¹Ïªíªº¬ÛÃö°ÝÃD

½Ð±Ð¦Û°Ê¹Ïªíªº¬ÛÃö°ÝÃD

½Ñ¦ì¥ý¶i

    ³Ìªñ¶}©l¾ÇVBA¡A·Q­n¦b¿W¥ßªº¹Ïªí¤W¥[¤J¤G­Ó¤U©Ô¦¡¿ï³æ¨Ó¦Û°Ê§ó·s·Q¬Ýªº¹Ïªí¡A¤@­Ó¬O¿ï¾Ü¸ê®Æ¨Ó¦Û­þ¤@­Ó¤u§@ªí¡A¥t¤@­Ó¬O¤u§@ªí¤¤ªº¸ê®Æ½d³ò¡C
§Úªº§@ªk¬O¥Îªí³æ±±¨î¶µ©Ô¥X¨â­Ó¤U©Ô¦¡¿ï³æ¡A¸Ì­±¤º®e³sµ²¨ä¥¦¦a¤è¡A·Q­n¼¶¼gvba®É¡A«oµLªk±oª¾³o¨â­Ó¤U©Ô¦¡ªºname¡A¾É­P«áÄòµLªk°Ê§@¡Agoogle¤F¤@°}¤l¡A¦ü¥G¨S¦³³oÃþ°ÝÃDªº¸Ñµª¡A¦³¤@»¡ªk¬O¥Îactive X¡A¤£¹L§Ú¦w¥þ©Ê¶}³Ì¤j¡A¤]µLªk¦bchart¤¤´¡¤Jactive Xªº¿ï³æ¡C

½Ð°Ý¦U¦ì¥ý¶i¦³½Ö¥i¥HÀ°§Ú¹jªÅ§ìßÓ¡A¬Ý§Ú­þ¸Ì«ä¸ô¦³°ÝÃD¡AÁÂÁ¡C

¦^´_ 1# alsr


    ­n¨ú±oªí³æ±±¨î¶µªº­È
¨Ò¦p¤U©Ô¿ï³æ1¡A³]©w¿é¤J½d³òA2:A4
With Shapes("Drop Down 1").OLEFormat.Object 'Ãö©ó¤U©Ô¿ï³æ1ªºOLEª«¥ó
  MyText= Range(.ListFillRange)(.Value) '¨ú±o¿ï¾Üªº¤å¦r
End With
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


·PÁª©¥D¡A¤p§Ì¸Õ¹L¡Aµo²{¦³¨â­Ó°ÝÃD¡A·Ð½Ð¤£§[¸Ñµª
¤@¡B§Ú¦b¹Á¸Õ¦b¤u§@ªí²K¥[³o¬qµ{¦¡½X¤¤¡AÃB¥~²K¥[ MsgBox mytext¨Ó¹Á¸Õ¬O§_¦³°ÝÃD¡A¥i¬O§Úµo²{msgbox¥u·|¥X²{¤@¦¸¡A·í§Ú¨Ï¥Î¤U©Ô¦¡¿ï³æ¦A¿ï¤@¦¸ªº®É­Ô¡A´N¤£·|¥X²{°T®§¤F¡A·Q½Ð±Ð­Y­n½T»{¨C¦¸§ó·s¤U©Ô¦¡¿ï³æ®É¡Amytextªº­È¦³Åܤƪº¸Ü¡Aµ{¦¡½XÀ³¦p¦ó§ï¼g?

¤G¡B§Ú¦³¦b¦P¤@­Óchart­¶­±¥t¥~¦A©Ô¤@­Ó«ö¶s¡A·Q­n¥Î«ö¶s¥h½T©w¨â­Ó¤U©Ô¦¡¿ï³æªº­È¦b¥t¥~­«·sø¹Ï¡A¦ý¬O¦b¸Ì­±ªºµ{¦¡½X²K¥[ª©¥Dªºµ{¦¡½X®É¡Aµo²{excelÅã¥Ü¤£»{ÃÑshpaes³o­Ósub¡A½Ð°Ý­ì¦]¨Ó¦Û¦ó³B¡C

·P®¦¡C

TOP

¦^´_ 3# alsr

­º¥ý½T©w§Aªº¤U©Ô¿ï³æ¬Oªí³æ±±¨î¶µ©Î¬Oactive X±±¨î¶µ¡H
½Ð¤W¶ÇÀÉ®×¥H«K¾é¸Ñ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  alsr

­º¥ý½T©w§Aªº¤U©Ô¿ï³æ¬Oªí³æ±±¨î¶µ©Î¬Oactive X±±¨î¶µ¡H
½Ð¤W¶ÇÀÉ®×¥H«K¾é¸Ñ
Hsieh µoªí©ó 2014-4-30 09:38




    ª©¥D±z¦n¡A§Úªº¤U©Ô¿ï³æ¬Oªí³æ±±¨î¶µ

Àɮצp¤U¡A§Ú·Q¥Î¤U©Ô¿ï³æ¨Ó½Õ¾ã¸ê®Æ§ì¨úªº½d³ò¡A§Æ±æ±z¯àµ¹§Ú«Øij¡AÁÂÁ¡C 234.rar (16.73 KB)

TOP

¦^´_ 5# alsr

§Ú·Q§A¬O§Æ±æÂI¿ï¤U©Ô²M³æ«á´N¯à°õ¦æÅÜ´«¸ê®Æ¨Ó·½
±Nµ{§Ç¼g¦b¤@¯ë¼Ò²Õ
  1. Public Sub chart_change()
  2. With ActiveChart
  3.    With .Shapes("Drop Down 1").OLEFormat.Object 'Ãö©ó¤U©Ô¿ï³æ1ªºOLEª«¥ó
  4.    mytext = Range(.ListFillRange)(.Value) '¨ú±o¿ï¾Üªº¤å¦r
  5.    End With
  6.   With .Shapes("Drop Down 2").OLEFormat.Object 'Ãö©ó¤U©Ô¿ï³æ1ªºOLEª«¥ó
  7.   mytext2 = Range(.ListFillRange)(.Value) '¨ú±o¿ï¾Üªº¤å¦r
  8.   End With
  9. .SetSourceData Source:=Sheets(mytext).Range("A:A").Find(mytext2, lookat:=xlWhole).Resize(, 17)
  10. End With
  11. End Sub
½Æ»s¥N½X
±N¨â­Ó¤U©Ô²M³æ³£«ü©w¥¨¶°±Ò°Ê¸Óµ{§Ç
play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  alsr

§Ú·Q§A¬O§Æ±æÂI¿ï¤U©Ô²M³æ«á´N¯à°õ¦æÅÜ´«¸ê®Æ¨Ó·½
±Nµ{§Ç¼g¦b¤@¯ë¼Ò²Õ±N¨â­Ó¤U©Ô²M³æ³£«ü©w ...
Hsieh µoªí©ó 2014-4-30 23:20


·P®¦¡A·P®¦

ÁÂÁÂHsieh¤jµL¨pªº±Ð¾É¡C

³o¨Ç¤âªkÅý¤p§Ì§Ú¤j¶}²´¬É¡A¦A¦¸·P®¦¡C

TOP

test2.rar (785.35 KB)
¦^´_  alsr

§Ú·Q§A¬O§Æ±æÂI¿ï¤U©Ô²M³æ«á´N¯à°õ¦æÅÜ´«¸ê®Æ¨Ó·½
±Nµ{§Ç¼g¦b¤@¯ë¼Ò²Õ±N¨â­Ó¤U©Ô²M³æ³£«ü©w ...
Hsieh µoªí©ó 2014-4-30 23:20



    ¦A¦¸½Ð±Ð¡A¦pªG§Úªº¹Ïªí·Q­n¥Î¨â²Õ¸ê®Æ¦¨¤@±ø½u¡A«h¸ê®Æ¸Ó¦p¦ó­«¼g?

¥t¡A½Ð±Ðª©¥D¡A¦pªG·Q¨ìª¾¹D¤U©Ô²M³æªºª«¥óªº«ü©w¦ì¸m¡A¦psheets(1).range("a1")¤§Ãþªº¡A¦³¤°»ò¼gªk¥i¥H¤F¸Ñ¶Ü¡AÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD