【整理】VBA学习资料整理

 

非常全的教程

http://www.360doc.com/userhome/30583536

http://lzhpq.blog.sohu.com/#tp_b639e94216a

https://leetcode-cn.com/

http://www.360doc.com/userhome/30583536

 

这个网站，还能用VBA操作Word和PPT，反正我是还没试过

http://www.exceloffice.net/archives/category/vba/ppt-vba

 

超级好的网站，还推荐了很多资源，看起来像是一个个人站

http://www.excelfans.com/category/office-reprinted

 

 

学习贴

https://www.douban.com/note/132261405/

完美EXCEL

https://www.jianshu.com/u/20ae0274bf65

https://blog.csdn.net/weixin_34088583/article/details/87767859

蓝色幻想

http://www.excelpx.com/thread-155353-1-1.html

 

VBA资料

http://club.excelhome.net/thread-470603-1-1.html、

http://club.excelhome.net/thread-390711-1-1.html

 

VBA数组资料

http://club.excelhome.net/thread-196095-1-1.html

http://club.excelhome.net/thread-1071321-1-1.html

http://club.excelhome.net/thread-770881-1-1.html

 

佛山小老鼠

http://club.excelhome.net/thread-1071321-1-1.html

http://club.excelhome.net/thread-933566-1-1.html

https://blog.csdn.net/mxhuicong/article/details/69808319

 

公式资料？

EH的大神很多，这个是大神之一，讲工作表函数的资料

http://club.excelhome.net/thread-933566-1-1.html

http://club.excelhome.net/thread-544345-1-1.html

https://blog.csdn.net/mxhuicong/article/details/69808319

 

还有收费网页论坛。。

http://www.excelwm.net/forum.php?mod=viewthread&tid=33&fromuid=1&tdsourcetag=s_pcqq_aiomsg

下面附内容和学习笔记把

自己学习和他们差距好大

 

微软官方VBA手册

https://docs.microsoft.com/zh-cn/office/vba/api/Excel.Worksheet.CodeName

https://docs.microsoft.com/zh-cn/office/vba/api/Excel.Workbooks.Item

最权威的资料，有很多人上去写了类百科的例子，有很多实例代码可以学习

 

网上教程(重要的是学例子)

 

这个网站也有很多语言教程

yibai

https://www.yiibai.com/vba/vba_for_loop.html

w3c

https://www.w3cschool.cn/excelvba/excelvba-function.html

新w3c

http://www.hechaku.com/vba/

 

好论坛

vba 那本书对应的

http://club.excelhome.net/thread-1192282-1-1.html

http://club.excelhome.net/thread-470603-1-1.html

 

 

 

几大博客网写的经验博客

很多例子

https://blog.csdn.net/taller_2000/article/category/7463892/4?

 

https://www.jianshu.com/u/a1bf0749eb73

http://www.cnblogs.com/wuzhiblog/p/vba_zero.html

https://blog.csdn.net/bangemantou/article/category/6681485

https://www.jianshu.com/u/fcd79d9abd60

 

 

电子书

headfirst的书的网站，有不少资料

https://resources.oreilly.com/examples?filter=head%20first%20C%23

 

 

VBA资源

https://www.zhihu.com/topic/19616936/hot

https://www.jianshu.com/u/233daefdef97

https://www.jianshu.com/p/fdfa2b56faa8

http://www.360doc.com/userhome/30583536

http://lzhpq.blog.sohu.com/#tp_b639e94216a

https://leetcode-cn.com/

https://www.w3cschool.cn/excelvba/excelvba-InputBox2.html

https://blog.csdn.net/iamlaosong/category_2728711.html

http://ke.wooffice.net/ask.html

http://www.it1352.com/694854.html

http://tieba.baidu.com/f?kw=vba&ie=utf-8

https://blog.csdn.net/qq_41777527/category_7680379.html

http://www.360doc.com/content/18/0917/16/40606956_787426580.shtml

http://club.excelhome.net/thread-1165866-1-1.html

https://www.cnblogs.com/wzh313/articles/9737573.html

http://www.it1352.com/234453.html

https://www.cnblogs.com/ryueifu-VBA/p/11099415.html

https://blog.csdn.net/wang_zhenwei/article/details/78857933

https://www.cnblogs.com/wzh313/articles/9737573.html

https://cloud.tencent.com/developer/search/article-VBA

https://cloud.tencent.com/developer/article/1468729

https://zhuanlan.zhihu.com/p/83055878

QQ 群 VBA吧  VBA 学习吧等等

 

 

http://club.excelhome.net/thread-1480660-1-1.html
http://club.excelhome.net/thread-987597-1-1.html
http://club.excelhome.net/thread-1247269-1-1.html
http://club.excelhome.net/thread-1462924-1-1.html
https://blog.csdn.net/3150379/article/details/56680054
http://club.excelhome.net/thread-1036541-1-1.html
https://blog.csdn.net/xuming1209/article/details/53998982

http://club.excelhome.net/thread-1421366-1-1.html
http://club.excelhome.net/thread-1215868-1-1.html
http://club.excelhome.net/thread-868892-1-1.html
https://blog.csdn.net/taller_2000/article/details/79465756
http://www.excelpx.com/thread-306718-1-1.html
https://zhidao.baidu.com/question/117540228.html
https://bbs.csdn.net/topics/390375345
http://www.excelpx.com/thread-419438-1-1.html
https://stackoverflow.com/questions/18063224/excel-vba-fso-getfolderfolderpath-working-in-2007-but-not-2010
http://www.360doc.com/content/19/1109/10/644962_872035105.shtml
http://club.excelhome.net/thread-959260-1-1.html
http://club.excelhome.net/thread-1109943-1-1.html
http://club.excelhome.net/forum.php?mod=viewthread&tid=1187209&extra=
http://club.excelhome.net/forum.php?mod=viewthread&page=1&tid=1330860
http://www.exceloffice.net/archives/966

 

VBA的一个例子网站

http://www.exceloffice.net/archives/category/vba/conceptual-topics

http://www.it610.com/article/1738497.htm

 

 

表单操作
http://www.360doc.com/content/17/1112/16/1353678_703173128.shtml
https://blog.csdn.net/yaroo/article/details/78773414
教程
https://www.yiibai.com/vba/vba_for_loop.html

https://www.jb51.net/office/excel/491895.html

http://club.excelhome.net/thread-1252419-1-1.html

http://club.excelhome.net/forum.php?mod=viewthread&tid=1310859

VBA的一个例子网站

http://www.exceloffice.net/archives/category/vba/conceptual-topics

http://www.it610.com/article/1738497.htm

REM注

表单操作
http://www.360doc.com/content/17/1112/16/1353678_703173128.shtml
https://blog.csdn.net/yaroo/article/details/78773414
教程
https://www.yiibai.com/vba/vba_for_loop.html

msgbox
https://www.cnblogs.com/mq0036/p/6169957.html

• 只能是模块里的 函数 才可以在excel里被直接使用，也就是放在对象脚本里的无法使用
• 使用方法和普通函数一样   =func(b1,b2)
• 但是我实测，这种cells赋值的为啥不可以？
• http://club.excelhome.net/thread-813525-1-1.html
• http://club.excelhome.net/thread-338141-1-1.html
• http://club.excelhome.net/thread-1143692-1-1.html

Range("b7").End(xlToRight).Select
http://www.dzwebs.net/3645.html

http://club.excelhome.net/thread-1222920-1-1.html

怎么传递参数？

inputbox 

Range("b7").End(xlToRight).Select
http://www.dzwebs.net/3645.html

 

https://blog.csdn.net/lsj308/article/details/24815275

关注UP

https://www.jianshu.com/users/f734a764dfe5/following

https://me.csdn.net/follow/xuemanqianshan

https://www.jianshu.com/users/a1bf0749eb73/following

https://blog.csdn.net/angryfishfish?t=1

https://blog.csdn.net/lsj308/category_2312603.html

https://blog.csdn.net/chenqiai0/category_6345126.html

 

P叔

https://blog.csdn.net/puzzy3d/article/details/1126836

 

 

网站---很多案例

http://www.excelfans.com/category/office-resources

http://xuliewei.cn/archives/category/jingyan/computer/excel-edu/excel-vba

http://www.dzwebs.net/AllArticle6-0.html

http://www.exceloffice.net/archives/2432

 

整理贴

http://club.excelhome.net/thread-1002093-1-24.html?jdfwkey=emn3s1

 

https://baijiahao.baidu.com/s?id=1632426332624429299&wfr=spider&for=pc

https://blog.csdn.net/sqq513/article/details/78803451

https://wenku.baidu.com/view/62489e9149649b6649d7470b.html

 

 

https://blog.csdn.net/taller_2000/article/details/86764802
https://blog.csdn.net/taller_2000/article/details/86767353
https://blog.csdn.net/gordennizaicunzai/article/details/79439587
http://www.360doc.com/content/17/1125/07/30583536_706921502.shtml

还有find方法
一列拆多列
http://club.excelhome.net/thread-1106858-1-1.html
http://club.excelhome.net/thread-1105404-1-1.html
http://club.excelhome.net/thread-568297-1-1.html

2 vba collection
http://club.excelhome.net/thread-1032842-1-1.html
可以用collection去数组重复
https://www.cnblogs.com/sylar-liang/p/5563610.html
 

 

 

 

1 查一个区域的边界不好查
VBA 查一个范围的边界

取数组的某一维
application.index(arr,1,0)

或
for i=1 to ubound(arr)
msgbox arr(i,2)
next

3
F8  逐行运行
F5 不停的运行一段代码

4 2维数组嵌套，其实还是二维数组

5
数组没有方法取 name, 数组名就是名字
字典是对象，也没有 name属性，字典名就是名字

split分列分出的数组，每个元素都是 字符串
需要int() 转一下

如果有非数字类的 isnumeric
可以报错处理下 iserror()

EXCEL

mod(10,3)
int()
len()

VBA
10 mo 3
int()  cint()
len()  lenb()   application.len()错

target1 = Application.InputBox("请输入您用于分隔的符号，只能1个,注意全角半角", "输入1个分隔符")
Set target_area1 = Application.InputBox("请选择您想要查漏的范围，只能是1列", "请选择1列", Type:=8)
'选1个范围比较麻烦，之后有机会再修改
target_area1.Select

cr = Application.CountA(Selection)
minr = Selection.End(xlUp).Row
maxr = Selection.End(xlUp).Row

https://blog.csdn.net/taller_2000/article/details/86764802
https://blog.csdn.net/taller_2000/article/details/86767353
https://blog.csdn.net/gordennizaicunzai/article/details/79439587
http://www.360doc.com/content/17/1125/07/30583536_706921502.shtml

还有find方法
一列拆多列
http://club.excelhome.net/thread-1106858-1-1.html
http://club.excelhome.net/thread-1105404-1-1.html
http://club.excelhome.net/thread-568297-1-1.html

2 vba collection
http://club.excelhome.net/thread-1032842-1-1.html
可以用collection去数组重复
https://www.cnblogs.com/sylar-liang/p/5563610.html

 

好的VBA博客

https://www.cnblogs.com/OliverQin/category/925889.html

 

 

技术书国内的一些书确实不好 ，尤其对新手太不友好

写书和做游戏一样

国内的很多书，不是对新手做的，反而像是自己的知识总结，甚至对切

比如《VBA基础入门 赵志东》 这种，内容举例完全就太难，知识也没有分层次推送给玩家

比如第3章讲workbook就开始讲事件，讲事件就开始举例禁止修改等等，明显内容不合适

这种书就像，新手留存低的游戏一样，必然是垃圾的

写书以后估计也得用游戏的这种思想

看通过率，毕竟这种基础技术书，不是技术讨论书籍，不是手册

老外的书籍就好得多