Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is a Property in Excel Visual Basic?

April 26, 2017Computer Computers Excel Property Software spreadsheet visual basic

0

Posted

What is a Property in Excel Visual Basic?

1 Answer

0

Posted

Visual Basic is an object oriented programming language, even in Excel VBA. One of the traits an object can have in Excel VBA is a property. Properties are often user defined, and are a way to get multi-function benefits out of a given chunk of code.Setting a PropertyThe SET procedure is used to attribute a value to a property. For example, assigning a value of a range of cells in Excel to a named property would use the function Set Range(A1)=1000 [integer].Retrieving a Value from a PropertyTo get a value from a property, you use the GET procedure call in Visual Basic. The format is Get [property name]. A Get procedure will only work if the access level of the code module is capable of reading the access level specified.Property Data TypesA property can be any valid data type, whether numeric (numbers with decimals), integers (numbers without decimals) or string (blocks of text that are not evaluated as numbers). The data type of the property is set with the Set command.Using Propertie