excel - 如何在VBA中声明全局变量？(How do I declare a global variable in VBA?)

Question

I wrote the following code:

(我写了以下代码：)

Function find_results_idle()

    Public iRaw As Integer
    Public iColumn As Integer
    iRaw = 1
    iColumn = 1

And I get the error message:

(我收到错误消息：)

"invalid attribute in Sub or Function"

(“ Sub或Function中的无效属性”)

Do you know what I did wrong?

(你知道我做错了吗？)

I tried to use Global instead of Public , but got the same problem.

(我尝试使用Global而不是Public ，但是遇到了同样的问题。)

I tried to declare the function itself as `Public, but that also did no good.

(我试图将函数本身声明为`Public，但这也没有好处。)

What do I need to do to create the global variable?

(创建全局变量需要做什么？)

  ask by Nimrod translate from so

Answer 1

You need to declare the variables outside the function:

(您需要在函数外部声明变量：)

Public iRaw As Integer
Public iColumn As Integer

Function find_results_idle()
    iRaw = 1
    iColumn = 1