vba global variables

[dgs2001]

Help please.

This i'm sure will be a simple one for somebody

Where do I define a variable in my code so that it is available for other sheets within the same workbook?
I have a Workbook Open () sub which assigns the next empty row on my bet recording sheet to variable blr however when I try to refer to blr
in a different sheet module I get
Run Time Error 1004
Application-defined or Object-defined error

Thanks Duncan

[/u]

[GeorgeUK]

I think i understand...

Code: Select all

public blr as string

sub workbook_open()
blr = now()
end sub


any other macro that refers to blr should then have the value that was inserted when the code read the "now" line.

[dgs2001]

Thanks George

I'm currently experiencing approx 50 'Urekka' moments a day !!!!

Your help is appreciated

[GeorgeUK]

Just let me know when you get a U-beauty moment