VBA两种情况边个快D
时间:2013-10-09
来源:互联网
想请教吓各CHING们,VBA里用IF...ELSEIF...同用CASE边种运算会快少少?
另外如果张经常发生的CONDITION放系头IF或者头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".
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
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28