Solve : (VBA) myCell.Value= 2, myCell.Text=xlLandscape?

1.	Solve : (VBA) myCell.Value= 2, myCell.Text=xlLandscape?
Answer» 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 advNot 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-)Thanks Resolved!

Discussion