Home / Software / Computer programming / (VBA) myCell.Value= 2, myCell.Text=xlLandscape
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] - (Bottom) Print
Author Topic: (VBA) myCell.Value= 2, myCell.Text=xlLandscape  (Read 2870 times)
keyven
Guest
« on: January 25, 2007, 06:57:24 PM »
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
IP logged
Sidewinder
Guru



Thanked: 97
Posts: 4,341

Experience: Familiar
OS: Windows 7
« Reply #1 on: January 26, 2007, 06:36:34 AM »
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-)
« Last Edit: January 26, 2007, 06:37:16 AM by Sidewinder » IP logged
If you don't know where you are going, any road will get you there

                                                                            -Lewis Carroll
keyven
Guest
« Reply #2 on: January 26, 2007, 09:45:30 AM »
Thanks :) Resolved! ;D
IP logged
Pages: [1] - (Top) Print 
Home / Software / Computer programming / (VBA) myCell.Value= 2, myCell.Text=xlLandscape « previous next »
 


Login with username, password and session length

Old Forum Search | Forum Rules
Copyright © 2010 Computer Hope ® All rights reserved.
Powered by SMF 2.0 RC3 | SMF © 2006–2010, Simple Machines LLC
Page created in 0.075 seconds with 20 queries.