excel consultant - Variables

The UK's most regular instructor-led training courses.
Training information: excel consultant · Microsoft excel training · Microsoft Office VBA training

Resolved · Low Priority · Version Standard

Variables

Jacky has attended:
Excel VBA course

by - delegate Jacky [5 posts] (2007 Aug 2 Thu, 16:42) Reply

how do you create a variable?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
2003	2008 Oct 30 Thu + 31 Fri	Bloomsbury	6	book now	£450	£485
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Variables

by - trainer Carlos gold contributer [413 posts] (2007 Aug 6 Mon, 15:50) Reply

Jacky

A variable needs to be declared before it can be used. To do this:

Dim/Public <variablename> as <type>

eg

Dim Area as Single

Public UserName as String

Regards

Carlos

· Tap the Power of Recorded Macros with MS Excel Courses
· How to Create Better Excel Spreadsheets: Part One
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· How to Create Better Excel Spreadsheets: Part Four

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips