在Excel中访问Vlookup宏代码? [英] Accessing Vlookup Macro Code in Excel?
问题描述
我希望在python中手动编码VLOOKUP,所以有可能看到VLOOKUP背后的VBA代码吗?我记得在我的学校里有一位嘉宾演讲者介绍了Excel Functions只是宏/vba代码.有人可以告诉我查看Excel Worksheet函数代码的方法吗?
I wish to manually code VLOOKUP in python, so is it possible to see the VBA code behind VLOOKUP? I remember a presentation in my school by a guest speaker showing that the Excel Functions are just macro/vba codes. Can someone please show me the way to view the code for Excel Worksheet functions?
推荐答案
我不知道Excel函数,但是可以使用Excel加载项.
Excel functions i dont' know, but to Excel Add-ins it's possible.
将加载项添加到excel应用程序中,然后转到Visual Basic编辑器,双击加载项并使用此密码.
Add a add-in to your excel application, and go to Visual Basic Editor, double click in add-in and use this passwords.
插件-密码
- Internet Assistant VBA-Weezaarde!?
- 自动保存插件-牛羚!!
- Analysis Toolpak VBA-牛羚!!
- Solver插件-牛羚!!
所有表单均应在旧版Excel中使用的excel表单中进行设计.
All forms be design in excel forms sheets used in older versions of Excel.
[]的
这篇关于在Excel中访问Vlookup宏代码?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!