方法/步骤
1,首先,我们打开要用VBA编程的office办公软件,这里以office Excel2013为例,其他版本打开方式相同;
![](https://iknow-pic.cdn.bcebos.com/eaf81a4c510fd9f95695a3712f2dd42a2834a42c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2,点击左上角的“文件”按钮;
![](https://iknow-pic.cdn.bcebos.com/8694a4c27d1ed21b0bf4dffda76eddc451da3fec?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3,点击“选项”按钮;
![](https://iknow-pic.cdn.bcebos.com/b17eca8065380cd70a4753f5ab44ad3459828149?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4,在弹出的对话框中,我们选择“自定义功能区”;
![](https://iknow-pic.cdn.bcebos.com/b58f8c5494eef01ffd43e9ddeafe9925bc317d57?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5,在自定义功能区界面,我们在右侧的“主选项卡”部分,找到“开发工具”选项,该选项默认不勾选,我们勾选该选项;
![](https://iknow-pic.cdn.bcebos.com/5d6034a85edf8db11beb8d7c0323dd54574e74e5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6,点击右下角的“确定”按钮,退出对话框;
![](https://iknow-pic.cdn.bcebos.com/d8f9d72a6059252d57d0ec1c3e9b033b5ab5b9e7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7,我们再次回到主界面,就可以看到“开发工具”选项卡;
![](https://iknow-pic.cdn.bcebos.com/48540923dd54564e467b1421b9de9c82d1584f88?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8,我们点击“开发工具”中的Visual Basic就可以开始VBA编程啦!
![](https://iknow-pic.cdn.bcebos.com/d8f9d72a6059252d57eeec1c3e9b033b5bb5b929?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)