Once we are able to Identify (or Reference) an Object in VBA, we are free to manipulate it by changing its characteristics (properties) or performing some action with it (methods). We will explore both these aspects in this video.
We will also, cover how to manipulate multiple properties and/or methods for the same object using With Statements.
#vba #excel
Follow the rest of the series, in the below playlist:
• VBA MasterClass
00:00 Intro
00:23 Setting Properties
03:28 With - End With Statements
06:58 Methods (with Arguments)
10:42 Don't Select Objects