精华内容
下载资源
问答
  • Excel VBA

    2016-12-05 14:23:44
  • excel vbaExcel VBA编辑和测试宏 (Excel VBA Edit and Test a Macro) In the Excel VBA Edit a Recorded Macro article, you saw the steps for making changes to an Excel macro that you had recorded. Excel ...

    excel vba宏

    writeicon

    In the Excel VBA Edit a Recorded Macro article, you saw the steps for making changes to an Excel macro that you had recorded.

    在“ Excel VBA编辑已记录的宏”文章中,您看到了对已记录的Excel宏进行更改的步骤。

    Excel VBA code edited

    I've uploaded a new video that shows the steps for editing the Excel macro, and stepping through the macro code by using the F8 key.

    我上传了一个新视频,其中显示了编辑Excel宏以及使用F8键逐步浏览宏代码的步骤。

    演示地址

    翻译自: https://contexturesblog.com/archives/2010/04/30/excel-vba-edit-and-test-a-macro/

    excel vba宏

    展开全文
  • excel vba代码大全 在Excel VBA代码中获取详细信息 (Get Details in Excel VBA Code)Did you ever get an Excel file from someone else, and try to sort out their Excel VBA code? Or, even worse, open an Excel...

    excel vba代码大全

    在Excel VBA代码中获取详细信息 (Get Details in Excel VBA Code)

    Did you ever get an Excel file from someone else, and try to sort out their Excel VBA code? Or, even worse, open an Excel file that you wrote long ago, and try to remember what all those variables mean?

    您是否曾经从其他人那里获得过Excel文件,并试图整理出他们的Excel VBA代码? 或者,更糟糕的是,打开您很久以前编写的Excel文件,并尝试记住所有这些变量的含义?

    I spend lots of time staring at Excel code, but apparently I don't use the right-click menu too often, because I hadn't noticed a couple of handy commands until recently.

    我花了很多时间盯着Excel代码,但是显然我不经常使用右键菜单,因为直到最近我才注意到几个便捷的命令。

    These commands can help you decipher that mysterious code, and unravel the complicated sections.

    这些命令可以帮助您解密该神秘代码,并解开复杂的部分。

    Excel VBA快速信息 (Excel VBA Quick Info)

    The first handy command is Quick Info. I have Auto Quick Info turned on in the VBE Editor options, and it helps me remember the syntax as I type the code.

    第一个方便的命令是快速信息。 我在VBE编辑器选项中启用了“自动快速信息”,这有助于我在键入代码时记住语法。

    excelvbainfo00

    What I didn't realize was that you can right-click on a variable, function, statement, method, or procedure in the code, and click Quick Info.

    我没有意识到的是,您可以右键单击代码中的变量,函数,语句,方法或过程,然后单击“快速信息”。

    excelvbainfo01

    A tooltip appears, with details on the selected item.

    出现工具提示,其中包含有关所选项目的详细信息。

    excelvbainfo02

    Excel VBA定义 (Excel VBA Definition)

    The other right-click command that I finally discovered is the Definition command.

    我最后发现的另一个右键单击命令是“定义”命令。

    excelvbainfo03

    Click the Definition command, and it takes you to the selected variable's definition. Finding the definition is easy in most procedures, but in a long procedure, with a long list of variables, the Definition command really makes the job easier.

    单击“定义”命令,它将带您到所选变量的定义。 在大多数过程中,找到定义都很容易,但是在长过程中,由于变量列表很长,Define命令确实使这项工作变得容易。

    It's especially helpful if the variable is defined on a different code module!

    如果变量是在其他代码模块上定义的,则特别有用!

    翻译自: https://contexturesblog.com/archives/2010/10/25/get-details-in-excel-vba-code/

    excel vba代码大全

    展开全文
  • excel vba代码大全 更改Excel VBA代码以提高速度 (Change Excel VBA Code to Improve Speed)In some of my files, macros run automatically when you select a cell on the worksheet. For example, if you've ...

    excel vba代码大全

    In some of my files, macros run automatically when you select a cell on the worksheet. For example, if you've bought a copy of my Data Validation Multi-Select Premium (DVMSP) kit, it shows a pop-up list when you click on a cell with a drop down list.

    在我的某些文件中,当您在工作表上选择一个单元格时,宏会自动运行。 例如,如果您购买了我的数据验证多选高级(DVMSP)套件的副本,则在单击带有下拉列表的单元格时,它将显示一个弹出列表。

    I'll show you how to quickly change that, so the pop-up appears when you double-click, and you could make a similar change in other worksheet code.

    我将向您展示如何快速进行更改,因此,当您双击该弹出窗口时,您可以在其他工作表代码中进行类似的更改。

    使用双击 (Use a Double-Click)

    If you find that the DVMSP code is slow in a big workbook, or if you don't want to see the pop-up list as you move around the workbook, you can make a simple change to its code.

    如果发现大型工作簿中的DVMSP代码运行缓慢,或者在工作簿中移动时不希望看到弹出列表,则可以对其代码进行简单的更改。

    Instead of showing the pop-up list when a cell is selected, change the code to run when a cell is double-clicked. That should speed things up a bit, and the pop-up list will only appear when you want it to.

    选中单元格时,不用显示弹出列表,而是将代码更改为在双击单元格时运行。 这样可以加快速度,并且仅在您需要时才会显示弹出列表。

    更改DVMSP代码 (Change the DVMSP Code)

    To make the pop-up list appear on a double-click, follow these steps to make a couple of simple changes to the code:

    要使弹出列表双击显示,请按照以下步骤对代码进行几个简单的更改:

    • On the sheet where you pasted the code, right-click the sheet tab, and click View Code.

      在粘贴代码的工作表上,右键单击工作表选项卡,然后单击“查看代码”。
    • At the top of the code module, click in the blank row above the Private Sub Worksheet_SelectionChange line

      在代码模块的顶部,单击Private Sub Worksheet_SelectionChange行上方的空白行。
    Worksheet_SelectionChange code http://blog.contextures.com/
    • At the top right of the window, click the arrow in the Procedures drop down, and click on BeforeDoubleClick

      在窗口的右上角,单击“过程”下拉菜单中的箭头,然后单击“ BeforeDoubleClick”
    Worksheet_BeforeDoubleClick code http://blog.contextures.com/
    • Select from the End Sub line, down to the Private Sub Worksheet_SelectionChange line

      从“结束子”行中选择,然后向下到“私人子工作表_选择更改”行
    • Delete those lines

      删除这些行
    Delete lines of code http://blog.contextures.com/
    • Scroll down a bit, to the first "Select Case Target.Column" section

      向下滚动到第一个“ Select Case Target.Column”部分
    • Click in the blank line above that section

      单击该部分上方的空白行
    • In the blank line, type: Cancel = True (that turns off the default double-click action, such as entering the cell to edit it)

      在空白行中,键入: Cancel = True (这将关闭默认的双击操作,例如输入要对其进行编辑的单元格)

    • Then, click the Save button, at the top right of the Visual Basic Editor window.

      然后,单击“ Visual Basic编辑器”窗口右上方的“保存”按钮。
    Add Cancel = True code http://blog.contextures.com/

    获取DVMSP套件 (Get the DVMSP Kit)

    If you don't have a copy of my DVMSP kit, you can learn more about it here. You can add this feature to your workbooks, and then use them yourself, or share them with your co-workers. They'll be impressed!

    如果没有我的DVMSP套件的副本,可以在此处了解更多信息 。 您可以将此功能添加到您的工作簿,然后自己使用它们,或与您的同事共享。 他们会留下深刻的印象!

    了解有关Excel宏的更多信息 (Learn More About Excel Macros)

    Closes Sunday, Feb. 7th – Would you like to learn how to save time with Excel macros? Take a look at the free Mini Course on Macros & VBA -- an excellent video series by Jon Acampora, from Excel Campus. Jon’s simple step-by-step approach makes it easy to follow along and learn, so get started now!

    2月7日星期日关闭 –您想学习如何使用Excel宏节省时间吗? 观看免费的Macros&VBA迷你课程 -Excel Campus的Jon Acampora的精彩视频系列。 乔恩(Jon)的简单循序渐进方法使后续操作和学习变得容易,因此立即开始!

    翻译自: https://contexturesblog.com/archives/2016/02/04/change-excel-vba-code-to-improve-speed/

    excel vba代码大全

    展开全文
  • Excel VBA 典型实例

    2019-03-13 15:29:36
    Excel VBA 典型实例 通过实例学习excel VBA Excel 2010版本
  • VBA挑战 Excel VBA作业
  • excel vba打印模板 Excel VBA视频:打印前显示消息 (Excel VBA Video: Show Message Before Printing) If the customer name is missing from an Excel worksheet order form, you'll waste paper if you print that...
  • excel vba编程

    2018-11-16 13:56:48
    excel vba编程 ,大量实例, 迅速掌握 更好的完成excel上面的编程
  • 最初开始接触VBA,是从Excel开始。然后延展到Access, Word, Outlook, Powerpoint和Visio. 很多VBA初学者最初接触的大概也是Excel VBA对象模型。Excel VBA对象模型看起来比较复杂 (下图是部分对象模型),但常用到的...
  • EXCEL VBA函数手册

    2018-10-31 14:07:51
    EXCEL VBA函数手册 很实用的EXCEL VBA函数手册值得收藏
  • excel vba复制黏贴 Using VBA to program Excel isn't as popular as it once was. However, there are still plenty of programmers who prefer it when working with Excel. If you are one of those people, this...
  • Excel VBA书籍

    2016-08-02 00:10:51
    两本书籍:《别怕,Excel VBA其实很简单完整版》和《Excel-VBA教程完全版》
  • EXCEL VBA就是利用VBA控制EXCEL应用程序 VBA与VB的区别? VBA与VB的代码编写时类似的 其不同之处在于 一、VB是一门编程语言,可以独立运行在任意安装有操作系统的计算机上 VBA则必须“寄生”于它所控制的应用...
  • excel vba刷新代码 Excel开发如此容易进行的主要原因之一是Macro Recorder( 工具 / 宏 / 记录新宏... )可以生成一些(尽管很基本)代码供您查看和构建。 不知道正确的对象吗? 不确定正确的程序吗? Excel可以为您...
  • [Wrox] Excel VBA 24小时快速入门 (英文版) [Wrox] Excel VBA 24-Hour Trainer (E-Book) ☆ 图书概要:☆ Excel VBA 24-Hour Trainer: Introduces you to VBA and discusses topics including object oriented ...
  • Excel VBA代码范例

    2016-10-13 08:26:49
    Excel VBA代码范例,内含Excel VBA各个方面的编程示例
  • Excel VBA语法与应用手册》内容简介:Excel VBA是一种简单易学的编程语言,《Excel VBA语法与应用手册》将引导读者从零开始全面掌握Excel VBA。通过《Excel VBA语法与应用手册》的学习用户可以了解Excel VBA的基础...
  • Excel VBA 详解

    2012-12-18 19:48:34
    Excel VBA 完整版,从基础到应用,详细介绍了Excel VBA
  • 微软Excel VBA手册,Excel VBA 对象属性方法及使用示例。Excel VBA 对象属性方法及使用示例。
  • excel VBA 文件合并

    2018-10-05 20:58:19
    excel VBA 文件合并, 代码与大家分享,一起成长!
  • PDF电子书:别怕,Excel VBA其实很简单第2版 , 本书 完整 高清 带书签目录 并含带了 随书案例 !
  • Excel Vba基础

    2018-11-15 08:21:29
    Excel Vba基础
  • ExcelVBA操作MySQL

    2012-02-16 22:36:26
    1. ExcelVBA操作MySQL之一——准备工作 2. ExcelVBA操作MySQL之二——链接MySQL 3. ExcelVBA操作MySQL之三——有关用户名和密码的操作 4. ExcelVBA操作MySQL之四——创建数据库和表 5. ExcelVBA操作MySQL之五——...
  • excelVBA配套资源.zip

    2020-05-27 17:32:11
    excelVBA配套资源.zip
  • Excel VBA语法辞典

    2014-09-19 08:56:44
    Excel VBA语法辞典》详细介绍了Excel VBA语法,希望给学习Excel 的小伙伴们一点点帮助
  • Excel VBA开发自动发送邮件

    万次阅读 多人点赞 2017-04-27 17:37:33
    若没有做如下操作设置,则Excel VBA调用Outlook自动发送邮件时提示如下 2.1 Outlook->工具->信任中心 2.2 编程访问->选中”从不向我发出可疑活动警告(不推荐)“,注意:建议使用Excel VBA自动发送...
  • Excel VBA参考手册CHM

    2019-02-22 11:31:23
    EXCEL VBA手册很全面,非常的实用哦

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 13,558
精华内容 5,423
热门标签
关键字:

excelvba