vba编程教程是什么
vba编程入门教程:
1、打开vba编辑器
打开vba编辑器有下边三种方法供大家使用:
方法1:点击excel菜单中的【开发工具】,然后在代码选项卡中点击【Visual Basic】 即可,如下图所示:
方法2:右击excel左下角【Sheet1】,在弹出的菜单中点击【查看代码】即可,如下图所示:
2、编写第一个vba程序
步骤:通过上边的方法打开vba编辑器。
在第一个下拉菜单中选中【worksheet】,在第二个下拉菜单中选中【BeforeDoubleClick】(BeforeDoubleClick的意思是在本工作表鼠标双击之前发生)。
然后编辑器中会自动生成两行代码,我们在两行代码之间写入自己的代码即可。比如我们输入:“Sheet1.Cells(2, 3) = Sheet1.Cells(2, 1) + Sheet1.Cells(2, 2)”。意思是当我们鼠标双击时触发,第二行第三列的单元将显示第二行第一列和第二行第二列的和。-vba
VBA的英文全称是Visual Basic for Applications,是一门标准的宏语言。VBA语言不能单独运行,只能被office软件(如:Word、Excel等)所调用。
VBA是一种面向对象的解释性语言,通常使用来实现Excel中没有提供的功能、编写自定义函数、实现自动化功能等。
MySQL基础教程-绝对推荐
MySQL学习路线(针对DBA)
1.深入学习SQL;
2.了解MySQL 体系结构、MySQL 安全、MySQL 监控与运维、MySQL 备份与恢复、MySQL 集群、MySQL 操作与管理、MySQL 架构等等,这里面有很多知识,本人也在学习中,就不展开了;
3.在实践中提高,多总结,多积累。-教程
学习教程:
DELPHI视频教程
http://202.116.65.193/ncourse/DELPHI/cxsj-01.csf
http://202.116.65.193/ncourse/DELPHI/cxsj-02.csf
http://202.116.65.193/ncourse/DELPHI/cxsj-03.csf
http://202.116.65.193/ncourse/DELPHI/cxsj-04.csf
http://202.116.65.193/ncourse/DELPHI/cxsj-05.csf
http://202.116.65.193/ncourse/DELPHI/cxsj06.csf
http://202.116.65.193/ncourse/DELPHI/cxsj07.csf
http://202.116.65.193/ncourse/DELPHI/cxsj08.csf
http://202.116.65.193/ncourse/DELPHI/cxsj09.csf
http://202.116.65.193/ncourse/DELPHI/cxsj10.csf
http://202.116.65.193/ncourse/DELPHI/cxsj11.csf
http://202.116.65.193/ncourse/DELPHI/cxsj12.csf
http://202.116.65.193/ncourse/DELPHI/cxsj13.csf
http://202.116.65.193/ncourse/DELPHI/cxsj14.csf
http://202.116.65.193/ncourse/DELPHI/cxsj15.csf
http://202.116.65.193/ncourse/DELPHI/cxsj16.csf
http://202.116.65.193/ncourse/DELPHI/cxsj17.csf
http://202.116.65.193/ncourse/DELPHI/cxsj18.csf
http://202.116.65.193/ncourse/DELPHI/cxsj19.csf
http://202.116.65.193/ncourse/DELPHI/cxsj20.csf
http://202.116.65.193/ncourse/DELPHI/cxsj21.csf
http://202.116.65.193/ncourse/DELPHI/cxsj22.csf
http://202.116.65.193/ncourse/DELPHI/cxsj23.csf
http://202.116.65.193/ncourse/DELPHI/cxsj24.csf
http://202.116.65.193/ncourse/DELPHI/cxsj25.csf
http://202.116.65.193/ncourse/DELPHI/cxsj26.csf
http://202.116.65.193/ncourse/DELPHI/cxsj27.csf
http://202.116.65.193/ncourse/DELPHI/cxsj28.csf
http://202.116.65.193/ncourse/DELPHI/cxsj29.csf
http://202.116.65.193/ncourse/DELPHI/cxsj30.csf
http://202.116.65.193/ncourse/DELPHI/cxsj31.csf
http://202.116.65.193/ncourse/DELPHI/cxsj32.csf
http://202.116.65.193/ncourse/DELPHI/cxsj33.csf
http://202.116.65.193/ncourse/DELPHI/cxsj34.csf
http://202.116.65.193/ncourse/DELPHI/cxsj35.csf
http://202.116.65.193/ncourse/DELPHI/cxsj36.csf
http://202.116.65.193/ncourse/DELPHI/cxsj37.csf
http://202.116.65.193/ncourse/DELPHI/cxsj38.csf
http://202.116.65.193/ncourse/DELPHI/cxsj39.csf
http://202.116.65.193/ncourse/DELPHI/cxsj40.csf
http://202.116.65.193/ncourse/DELPHI/cxsj41.csf
http://202.116.65.193/ncourse/DELPHI/cxsj42.csf
http://202.116.65.193/ncourse/DELPHI/cxsj43.csf
http://202.116.65.193/ncourse/DELPHI/cxsj44.csf
http://202.116.65.193/ncourse/DELPHI/cxsj45.csf
http://202.116.65.193/ncourse/DELPHI/cxsj46.csf
http://202.116.65.193/ncourse/DELPHI/cxsj47.csf
http://202.116.65.193/ncourse/DELPHI/cxsj48.csf
http://202.116.65.193/ncourse/DELPHI/cxsj49.csf
http://202.116.65.193/ncourse/DELPHI/cxsj50.csf
http://202.116.65.193/ncourse/DELPHI/cxsj51.csf
一共51讲~~中山大学delphi视频教程
-vba