+ -
当前位置:首页 → 问答吧 → VBA两种情况边个快D

VBA两种情况边个快D

时间:2013-10-09

来源:互联网

想请教吓各CHING们,VBA里用IF...ELSEIF...同用CASE边种运算会快少少?
另外如果张经常发生的CONDITION放系头IF或者头CASE运算系咪会快少少?

作者: alee001   发布时间: 2013-10-09

http://stackoverflow.com/questio ... seif-or-select-case
There are some similar discussion in here. Notes some of them are VBA, but some are in other languages.
However, in general the total number of cases is quite important on thinking about performance.

p.s. Given "If" Vs "Case", I bet on "Case".

作者: ricyik   发布时间: 2013-10-09

Thks for your reference, I think to CASE more 1 step then ELSEIF, but there are good expressive of code.

作者: alee001   发布时间: 2013-10-09