Excel VB问题 [英] Excel VB question

问题描述

我对excel知之甚少，如果有人浏览过Access论坛，我只是试着用VB编码。


是否可以在Excel中执行VB代码这将查看我所有四个标签中的列F，以及列F中的单元格是否显示已完成。它将被移动到另一个被称为已完成的标签。在我的工作簿中？

I know very little about excel and if anyone has looked through the Access forum i am just gettting my feet wet with VB coding.

Is it possible to do VB code in Excel that will look at a column F in all four of my tabs, and if a cell in the column F says "completed" it will be moved to another Tab Called "completed" in my work book?

推荐答案

可以在Excel中编码。它叫做编写宏。

按Alt + F11在excel表格上你需要编码，编辑器会打开，在那里你可以找到各种可以编写代码的事件。

但是VBA是Vb的子集，所以你找不到VB支持的所有功能。

It is possible to Code in Excel . Its called writing macros.
Press Alt+F11 On the excel sheet on which you need to do the coding the editor will open, there you will find various events on which you can write your code.
However VBA is a subset of Vb so you will not find all the features supported by VB.

可以在Excel中编码。它叫做编写宏。

按Alt + F11在excel表格上你需要编码，编辑器会打开，在那里你可以找到各种可以编写代码的事件。

但是VBA是Vb的一个子集，所以你不会找到VB支持的所有功能。

It is possible to Code in Excel . Its called writing macros.
Press Alt+F11 On the excel sheet on which you need to do the coding the editor will open, there you will find various events on which you can write your code.
However VBA is a subset of Vb so you will not find all the features supported by VB.

我已经开发了一个宏来执行此操作，我应该将它放入什么事件？

I have developed a macro to do this, what event should i place it in?

我已经开发了一个宏来执行此操作，我应该将它置于什么事件中？

I have developed a macro to do this, what event should i place it in?

好​​的，所以你已经编写了代码。如何/何时/在哪里运行？


您可以在工作表上放一个按钮并单击它！？

OK, so you have written the code. How/when/where do you want this to run?

You could just put a button on the sheet and click it !?

可以在Excel中编码。它叫做写宏。

It is possible to Code in Excel . Its called writing macros.

BTW作为票价因为我关注的是你记录的宏。只需单击工具栏上的按钮，VBA就可以做得更多。您可以在Excel中编写完全不使用电子表格功能的程序。你为什么这样？因为我在工作时没有VB6或.NET。


抱歉咆哮！


MTB

BTW as fare as I an concerned a macro is something you record. VBA can do very much more than you can do just clicking buttons on a toolbar. You can write programms in Excel that don''t use spreadsheet functionality at all. Why would you? Because I don''t have VB6 or .NET available at work.

Sorry about the rant!

MTB

这篇关于Excel VB问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！