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

[µo°Ý] excel vba ÄݩʬOªÅªº

¥»©«³Ì«á¥Ñ mark15jill ©ó 2013-4-8 09:25 ½s¿è

¦^´_ 1# symis

­Yª½±µ©ó¬¡­¶Ã¯¤W´¡¤J«ö¶s¡A¦³¨âºØ§Î¦¡
1.«ö¶s<ªí³æ±±¨î¶µ>-"«ö¶s"        ·|¥X²{¦b  Module1 ¤º

2.«ö¶s<ActiveX>-"=EMBED("Forms.CommandButton.1","")"      ·|¥X²{¦b  ¬¡­¶Ã¯  ¤º



1020325-004-001-001.jpg
2013-4-8 09:23
1020325-004-001-002.jpg
2013-4-8 09:23



¶}¥¨¶°ªº¸Ü¡A¿ï¶µ  > «H¥ô¤¤¤ß > «H¥ô¤¤¤ß³]©w > ¥¨¶°³]©w  ¦b¦Û¤v¬D¿ï

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

·PÁ°ª¤â­Ì¬Û§U,­ì¨Ó¥u­n¿é¤Jvbaªº±K½X,´N¯à¬Ý¨ìÄÝ©Ê,¦ý¬O§OªºÀɤ£¥Î³o¼Ë,why?
§OªºÀɤ]¬O¤@¼Ë¦³³]vba±K½X ...
symis µoªí©ó 2013-4-9 10:24



    §Ú·Q ±z¬O»~·|¤F...
     ³o¦ü¥G¸òVBA ±K½XµLÃö§a..

     ³æ¯Â ¦³µL¶}±Ò¥¨¶°... ªº¦]¯À...

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

Hi, mark15jill
¥i§_½Ð±z¸Õ¤@¸Õ?
Àɮצb: http://www.FunP.Net/767273
¾Þ§@¨BÆJ: (¨Ï¥ÎExcel 2007)
1. ...
symis µoªí©ó 2013-4-9 16:03



¦]¤£½T©w¦¹Àɮ׬O§_¯A¤Î¨ì¨ä¥LÃö³s
¬G¶È¥H ¹Ï¥Ü¸ÑÄÀ¦¹°ÝÃD¤§¬Ýªk
1020410.jpg
2013-4-10 08:47


ªþ±a¤@´£.. ³o¸ò±K½X¯uªºµLÃö= =
¥u¬OÂê©wªº°ÝÃD

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD