Global constant doubt in VBA.

[Jagdev Singh]

Hi Experts,

I have a doubt regarding constant variable.

I want to provide an input box to a variable as per the below code.

Dim strFldr As String

strFldr = InputBox("Please add folder link of the doc")

I want to use the same URL in 2 class or 1 class and 1 function is the module.

Regards,

JD

 

[Luke M]

You would put the definition for your variable at the top of a module, before any subs, as:

Public strFldr as String

'Rest of code follows
Sub SetValue()
strFldr = InputBox("Please add folder link of the doc")
End Sub

 

[Jagdev Singh]

Thanks Luke! for the explanation.

Regards,
JD