Variables

The UK's most regular instructor-led training courses.
Training information: vba excel course london · Excel advanced · VBA training UK

Resolved · Low Priority · Version 2000

Variables

Peter has attended:
Excel VBA course

by - delegate Peter [1 post] (2008 May 8 Thu, 16:40) Reply

If you create a variable as an integer and try to define text in the variable will an error occur?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Aug 12 Tue	Bloomsbury	0	FULL
2003/XP	2008 Aug 12 Tue	Tooting	0	FULL
2003/XP	2008 Aug 14 Thu	Southwark	0	FULL
2007	2008 Aug 19 Tue	Bloomsbury	5	book now	£212	£224
2003/XP	2008 Aug 21 Thu	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Aug 21 Thu	Bayswater	4	book now	£195	£205
Full Schedule: See all 145 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Variables

by - trainer Alan silver contributer [55 posts] (2008 May 18 Sun, 18:04) Reply

Yes.

If you want to allow varying types of data in a variable, do not declare a type. It will then accept any data.

· Tap the Power of Recorded Macros with MS Excel Courses
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· MS Excel: Excel At Making The Most Of Your Christmas
· Excel Macros for the Non-Programmer
· Compare Different MS Excel Training Methods

Please browse our web site to find out more about
vba excel course london and other Microsoft training courses.

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips