Dynamic property names
 

Hi all

In VBA/Excel is there any way I can dynamically refer to property
names. By this I mean that I want to pass a property name as a
parameter e,g,

sub aSub (aCell as Range, aVal as Variant, prop as ???)

....
aCell.prop = aVal ' or some such

....
end sub

so the input parameter "prop" could be "value" or "formula" or
whatever.

Many thanks

Tone

Dynamic property names
 

On 3 Jul, 14:39, Tone wrote:
Hi all

In VBA/Excel is there any way I can dynamically refer to property
names. *By this I mean that I want to pass a property name as a
parameter e,g,

sub aSub (aCell as Range, aVal as Variant, prop as ???)

...
* *aCell.prop = aVal *' or some such

...
end sub

so the input parameter "prop" could be "value" or "formula" or
whatever.

Many thanks

Tone

Answered my own question! - use the function "CallByName"

T