如题所述
两è
é½æ¯èµå¼ç¬¦ï¼ä½èµå¼ç对象ä¸åèå·²ã
1. := æ¯âæ¹æ³âçå é¨ååæ°èµå¼æ¶ä½¿ç¨çã
æ¯å¦è¯´Findï¼æ¥æ¾ï¼æ¹æ³ï¼å ¶è¯æ³å¦ä¸ï¼
1.expression.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat)
å½æ们æ³å¨Sheet1ä¸æ¥æ¾âå·¥æ¶â两个åæ¶ï¼å¯ä»¥è¿æ ·åï¼
1.Sheet1.Find(What:="å·¥æ¶", LookIn:=xlValues, LookAt:=xlWhole)
è¿éï¼Findå°±æ¯âæ¹æ³âï¼ç¸å½äºä¸»è¦è¿ç¨ï¼èæ¬å·å çWhatãAfterãLookInãLookAtãMatchCaseä¹ç±»çï¼å°±æ¯è¿ä¸ªæ¹æ³çåï¼å é¨ï¼åæ°ï¼å½ç»è¿äºå é¨åæ°èµå¼æ¶ï¼å°±è¦ç¨å°:=ã
å½ç¶ï¼ä¸é¢çè¯å¥ï¼å¦æä½ æåæ°ç顺åºåï¼ç¶åä¸èµå¼çåæ°ç¨éå·é¢çå ä½çè¯ï¼è¿äºååæ°çå称ä¹æ¯å¯ä»¥çç¥çï¼ä¹å°±å¯ä»¥çç¥:=è¿ä¸ªèµå¼ç¬¦ã
2. =æ¯ç»åéã对象èµå¼æ¶ä½¿ç¨çã
å¦ i = 55ãRange("A1").Value="Good Morning"ãSet Rng = Range("A1")ãSet dic = CreateObject("Scripting.Dictionary") ççã
1. := æ¯âæ¹æ³âçå é¨ååæ°èµå¼æ¶ä½¿ç¨çã
æ¯å¦è¯´Findï¼æ¥æ¾ï¼æ¹æ³ï¼å ¶è¯æ³å¦ä¸ï¼
1.expression.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat)
å½æ们æ³å¨Sheet1ä¸æ¥æ¾âå·¥æ¶â两个åæ¶ï¼å¯ä»¥è¿æ ·åï¼
1.Sheet1.Find(What:="å·¥æ¶", LookIn:=xlValues, LookAt:=xlWhole)
è¿éï¼Findå°±æ¯âæ¹æ³âï¼ç¸å½äºä¸»è¦è¿ç¨ï¼èæ¬å·å çWhatãAfterãLookInãLookAtãMatchCaseä¹ç±»çï¼å°±æ¯è¿ä¸ªæ¹æ³çåï¼å é¨ï¼åæ°ï¼å½ç»è¿äºå é¨åæ°èµå¼æ¶ï¼å°±è¦ç¨å°:=ã
å½ç¶ï¼ä¸é¢çè¯å¥ï¼å¦æä½ æåæ°ç顺åºåï¼ç¶åä¸èµå¼çåæ°ç¨éå·é¢çå ä½çè¯ï¼è¿äºååæ°çå称ä¹æ¯å¯ä»¥çç¥çï¼ä¹å°±å¯ä»¥çç¥:=è¿ä¸ªèµå¼ç¬¦ã
2. =æ¯ç»åéã对象èµå¼æ¶ä½¿ç¨çã
å¦ i = 55ãRange("A1").Value="Good Morning"ãSet Rng = Range("A1")ãSet dic = CreateObject("Scripting.Dictionary") ççã
温馨提示:答案为网友推荐,仅供参考
第1个回答 2007-11-19
:= 可以用于对方法参数的赋值
比如你定义了一个方法m(elem1 as ..., elem2 as ...)
在调用这个方法的时候
m elem11,elem21
可以写成
m elem1:=elem11,elem2:=elem21
这样说好像看不出来区别
这样比较看看
m2(elem1 as ...,elem2 as ...,elem3 as ...,elem4 as ...,elem5 as ...,elem6 as ...,elem7 as ...)
调用时
m ,,,,,elem61,
和
m elem6:=elem61本回答被提问者采纳
比如你定义了一个方法m(elem1 as ..., elem2 as ...)
在调用这个方法的时候
m elem11,elem21
可以写成
m elem1:=elem11,elem2:=elem21
这样说好像看不出来区别
这样比较看看
m2(elem1 as ...,elem2 as ...,elem3 as ...,elem4 as ...,elem5 as ...,elem6 as ...,elem7 as ...)
调用时
m ,,,,,elem61,
和
m elem6:=elem61本回答被提问者采纳
第2个回答 2007-11-19
:=
对对象的赋值
xxx:=1
等价于
Set xxx = 1
对对象的赋值
xxx:=1
等价于
Set xxx = 1