excel.advanced.course - Change an Object's Property

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

Resolved · Low Priority · Version Standard

Change an Object's Property

Neil has attended:
Excel VBA course

by - delegate Neil [1 post] (2008 Jan 18 Fri, 09:46) Reply

When can I just use code like:

Object = Value

and when do I need to use code like:

Set Object = Value

I'm not sure which applies in which case. Thanks!

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 21 Thu	Bloomsbury	0	FULL
2003/XP	2008 Aug 21 Thu	Bayswater	2	book now	£195	£205
2003/XP	2008 Aug 28 Thu	Southwark	0	FULL
2003/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003/XP	2008 Sep 2 Tue	Bloomsbury	4	book now	£207	£215
2003/XP	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
Full Schedule: See all 141 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Change an Object's Property

by - trainer Stephen gold contributer [326 posts] (2008 Feb 9 Sat, 11:16) Reply

Hi Neil

Thank you for your question

Simply put when you a assigning a value to an excel object then you must use the set command. So if you are naming a workbook, worksheet, range or other similar object use the set command.

however, if you are assigning a value to a simple variable then just use the variable = value syntax

Regards

Stephen

· What's Better Than the Help Function in Excel? Microsoft Training
· Microsoft Excel Training: Essential for Today's Employees
· Database Tips from an Excel Training Course
· Excel Macros for the Non-Programmer
· 5 Microsoft Excel Charts for Creating Stunning Business Documents