创建由组合键调用的VBA代码行 [英] Create lines of VBA code called by a key-combination

问题描述

我使用Access 2010有很多表单和数千行VBA代码。通过各种项目中的代码行手动搜索

我会发现例如下面一行代码（让我们称之为当前行）：

Hi, I use Access 2010 with a lot of forms and many thousands of lines of VBA code. When searching manually thru the codelines in the various projects
I will find e.g. the following line of code (let''s call it current line):

展开 | 选择 | Wrap | 行号

推荐答案

这里是一些类似于您尝试执行的操作：

Here are a few procedures that are similar to what you are attempting to do:

展开 | 选择 | Wrap | 行号

非常感谢，jforbes。在过去，我只尝试过一次处理代码模块。在其他方面，你的代码对我非常有帮助，不幸的是不是因为我的小问题。


从我当前的行开始你建议的SUB是必不可少的。每当我必须输入其他命令之前，我也可以从剪贴板中复制并粘贴我的新行 - 这似乎更容易。


你认为有办法写吗一个与脚本语言具有相同职责的程序，并通过一个键组合来启动它？


然而你的答案将是：我再次学到了很多东西然后再次：谢谢你

Thank you very much, jforbes. In the past I tried only once to handle with the codemodule. In some other way your code is very helpfull for me, unfortunetely not for my small problem.

To start your proposed SUB from my current line is essential. Whenever I have to type other commands before, I alternatively can just copy&paste my new line from the clipboard - this seems to be easier.

Do you think there is a way to write a procedure with the same duty from a scriptlanguage and start this by a key-combination?

However your answer will be: I again have learned a lot and therefor again: THANK YOU

这对我来说是一个非常有教育意义的话题。谢谢你们两位。


Jim

This has been a very educational thread for me. Thank you both.

Jim

这篇关于创建由组合键调用的VBA代码行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！