Excel 在哪里声明全局变量

1、声明一个变量并且给它赋值。

Declare a various and assign value by selectionchange event.

Option Explicit

Public myName As String

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

myName = Target.Address

End Sub

2、定义一个宏函数，用于显示全局变量是否有值

Define a function to display the value of global various such that we can see if work or not 

Sub Macro1()

'

' Macro1 Macro

' 宏由 微软中国 录制，时间: 2015-11-14

'

' 快捷键: Ctrl+q

'

    MsgBox myName

End Sub

3、我单击执行宏命令，通过按control +Q, 如图，提示框没有给我任何提示

I execute the function by pressing Control+Q, we can see the snapshot that it doesn't show any to me 

4、那么我们改一下全局变量声明的位置

so we change the position of global various

Option Explicit

Public myName As String

Sub Macro1()

'

' Macro1 Macro

' 宏由 微软中国 录制，时间: 2015-11-14

'

' 快捷键: Ctrl+q

'

    MsgBox myName

End Sub

5、我们再按一下Control+Q会得到提示框，如图所示

we press the control+Q again , we get the expected result as snapshot