Public Constants ???

[RoundCow]

i have a question about something, i would think would be easy. for a while now i have been making invisible labels to store values, there has to be an easier way. How do i make a value that can be used by any function?

[jritchie]

RoundCow, (as opposed to square cow l guess)

Declare a Global variable in a module calling right at the start of the project

e.g

basStart

Option Explicit
Global sCompanyName as String

Sub Main()

sCompanyName = "Acme Plumbing"

This will make the variable sCompanyName visible to all forms, modules, classes etc in your project.

[Janitor]

You can declare either global variables or constants.

If you want them available to all forms/modules in your project, put this in any module.

Public Const Constant_Name = 1
Global Variable_Name As String

Declare them at the top of a form to make them global in that form alone.

[RoundCow]

i put

Option Explicit
global scanstatus as String

in the declarations, and it didn't work... does it have to be in a bas?

[RoundCow]

coo, i did it in a module and it worked fine. thanks guys.

[KENNNY]

whats the diff between Public and Global?
cos variables declared with Public in a module are also visible throughtout the project.

------------------
cintel rules
www.cintelsoftware.co.uk

[Mark Sreeves]

Global is an outdated (vb3?)keyword but does the same as Public

[KENNNY]

ah ha

------------------
cintel rules
www.cintelsoftware.co.uk