Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel.advanced.course - Change an Object's Property
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel.advanced.course - Change an Object's Property
Resolved · Low Priority · Version Standard
Reply
Change an Object's Property
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!
For upcoming training course dates see: Pricing & availability
RE: Change an Object's Property
Hi NeilThank 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
|
 |
|
» Forum post: Excel VBA 2003 |
What are the similarities between VB and Excel VBA?
