ExcelBanter - Variables

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Variables (https://www.excelbanter.com/excel-programming/331972-variables.html)

lee

Variables

How do I declare a vairiable that will be available in other forms, I'm new
to VB and will need some examples please.

bac

Variables

Using

GLOBAL vname as vType

in place of:

Dim vname as vType

will make the varable available to all running processes for as long as this
instance of Excel remains open/running

bac

"Lee" wrote:

How do I declare a vairiable that will be available in other forms, I'm new
to VB and will need some examples please.

All times are GMT +1. The time now is 12:42 PM.