Excel

The UK's most regular instructor-led training courses.
Training information: financial excel course london · Microsoft+excel+training · VBA training UK

Resolved · Low Priority · Version 2003

Excel

Scott has attended:
Excel VBA course

by - delegate Scott [1 post] (2008 May 1 Thu, 16:51) Reply

how do you declare a public variable

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: excel

by - trainer Carlos gold contributer [360 posts] (2008 Jun 3 Tue, 10:23) Reply

Hi Scott

A public variable is a variable that can be accessed by all the sections of code in a project.

One example of the use of a Public variable is data being entered on a form that needs to be moved to a module.

As a good coding practice you should declare the public variable in the Option Explicit area of the code page

To declare a Public variable you use the following code

Public MyVariable As String

Hope this helps

Carlos