(VBA) myCell.Value= 2, myCell.Text=xlLandscape

[keyven]

How do I accomplish this? As in setting myCell to set the integer to 2 for any references, but to the end-user, it should just show "xlLandscape"

Thanks in adv

[Sidewinder]

Not sure that myCell would have a text property. You could reference another cell to get a value.

A1 = 2
A2 could then have a formula: =if(A1=2,"xlLandscape")

You'll create a circular reference if you attempt to use the cell being referenced in it's own formula.

 8-)

[keyven]

Thanks Resolved!