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

½Ð°Ý¦³¹Ï¤ù¨ç¼Æ¶Ü?

½Ð°Ý¦³¹Ï¤ù¨ç¼Æ¶Ü?

¦³¦bºô¸ô¤W§ä¨ì¤@¨Ç¤å³¹¦p¤U
¨DExcel¤¤¥Î¨ç数显¥Ü图¤ù问题? =if(A1="",A2"显¥Ü¬Y图©Î°Å贴画","显¥Ü¥t¤@´T图©Î°Å贴画")
悬赏¤À¡G100 - ¸Ñ决时间¡G2010-8-12 19:18
¤ñ¦p¡G当A1为ªÅ¥Õ内®e时¡AA2¬Y图©Î¬Y°Å贴画¡C当A1¦³内®e时¡AA2显¥Ü¡§显¥Ü¥t¤@´T图©Î°Å贴画¡CExcel¯à¤£¯à°µ¥X这样ªº¤½¦¡?¥Î¤°¤\¤èªk¯à实现¡A¦^µª¥¿Ú̪̤@©w给¤À¡C

´£问ªÌ¡G panwen - ¤­级³Ì¨Îµª®×¤£¥ÎVBA¤]¥i¥H实现ªº¡C
1¡B¥ý­ã备两张图¤ù¡A©ñ¦b两个单¤¸®æ¤¤备¥Î¡A¦p将¡§图¤ù1¡¨©ñ¦bsheet1¤¤ªºA1¡A¡§图¤ù2¡¨©ñ¦bA2¡]单¤¸®æªº¤j¤p­n¤ñ图¤ùªº边®Ø­n¤j¡A³Ì¤p¤]¬O刚¦n¡^

2¡B¥´开µæ单栏¤Wªº¡§´¡¤J¡¨¡Ð¡§¦W称¡¨¡Ð¡§©w义¡¨¡A¦b¡§¦b当«e¤u§@Á¡¤¤ªº¦W称¡¨输¤J¡§图¤ù¡¨¡A¦b¤U­±ªº¡§¤Þ¥Î¦ì¸m¡¨¤¤输¤J¡G
=OFFSET(Sheet1!$A$1,IF(Sheet2!$A$1="",0,1),0,1,1) 点¡§ÚÌ©w°h¥X¡C

3¡B¦b¥t¤@个ªí¡]¦p¡Gsheet2¡^¥´开µæ单栏¤Wªº¡§视图¡¨¡Ð¡§¤u¨ã栏¡¨¡Ð¡§±±¥ó¤u¨ã½c¡¨¡A¦b弹¥Xªº¤u¨ã条¤¤选择¡§¤å¥»®Ø¡¨¡A¦bA2¦ì¸m画¤@个ÉO图¤ù¤Ø¤o¬Ûµ¥ªº¤å¥»®Ø¡A选¤¤¤å¥»®Ø¦Z¦b编辑栏将¡G=EMBED("Forms.TextBox.1","") §ï为¡G=图¤ù ¦^车¦Z´N¥i¥H实现­n¨D¤F¡C
¦p¦ó¸Õ³£¤£¦æ¥u¥i¥H¨ì²Ä3´N¥H¨S¦³¿ìªk¡A½Ð°Ý«e½ú±Ï±Ï§Ú¡AÁÂÁÂ!!!
danny

Book1.rar (23.67 KB)

TOP

¦]Åv­­µLªk¤U¸ü
¥H¤W°ÝÃD·Q½Ð°Ý¬O§_¥i¥H¨Ï¥Î¨ç¼Æ¡A¨Ò¹Ï§ÎÀɪº¦ì¸m¬°a1,a1°Ñ¦Ò¦ì¸m¬°b1¬O§_¥i¥H°µªº¨ì
Áö¤£¯à¤U¸ü¦ýÁÙ¬OÁÂÁªO¥D¦^ÂÐ
danny

TOP

1.´¡¤J¨â­Ó¦WºÙ¡G
y=IF(Sheet2!$A$1="",0,1)
x=OFFSET(Sheet1!$A$1,y,,,)
textbox¤½¦¡¿é¤J=x
a.gif

TOP

«ö·Ó¤j¤j±Ð¾Éªº¦WºÙ=>©w¸q  aaa  °Ñ¼Æ¨ì=OFFSET(Sheet1!$A$1,y,,,),y=IF(Sheet2!$A$1="""""""",0,1)  ½T©w«á·|Åܬ°:=",x=OFFSET(Sheet1!$A$1,y,,,),y=IF(Sheet2!$A$1="""""""",0,1)"
¦p³æ­Ó:=",x=OFFSET(Sheet1!$A$1,y,,,)¤£ª¾¹D¹ï¤£¹ï
¦ý§Ú¦p¦ó¸Õ³£¨S¦³¿ìªk°µ¨ì¬O§_¨º¸Ì¦³¿ù£z
""=¬O§_¦³°ÝÃD¦³¿ù»~£«¡A¤p§Ì¤£¤~
³Â·Ð±z£z
danny

TOP

´N³o»ò²³æ¡A·ÓµÛ°µ´N¦æ¤F¡A¬Ý¤£À´§A§ï±o³o¼Ë¬O¦b°µ¤°»ò¡C

TOP

·Ó³o¥H¤WªO¥D°µÁÙ¬O°µ¤£¥X¨Ó¡A¬O§_¥i¥H¸Ô²Ó¸Ñ»¡¤@¤U¡CÁÂÁÂ!!
danny

TOP

§Ú²×©ó§ËÀ´£z¡A§Ú·Q½Ð°Ý¦p§Ú¦³4±i¹Ï¤ù¬O§_¥i¥H°µ¨ì£v
ÁÂÁÂ!!!
danny

TOP

§Aªº±ø¥ó¬OªÅ¥Õ®ÉÅã¥Ü¤@­Ó¹Ï¤ù¡A«DªÅ¥Õ®ÉÅã¥Ü¥t¤@­Ó¡A¥u¦³¨âºØÅܤơA­n¥|±i¹Ï¤ù¦ó¥Î¡H

TOP

¦]¬Oñ¦WÀɬO¾ã­Ó³æ¦ì¨Ï¥Î1. QC7=®}xx  2.  QC6=½±xx.  3.  QC0=ªÅ¥Õ
¦³20¦æ¦ì¬°Ã±¦W¦ì¸m

11.JPG (130.77 KB)

11.JPG

danny

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD