Referencing cell via a variable

[Udo Weik]

Hello,

is it possible to reference a cell via a variable,
e. g. the reference of the cell is
Sheet.135!User.Test0

Now I want to define a variable, so that I can
e. g. use
Sheet.135!User.Test0
Sheet.135!User.Test1
Sheet.135!User.Test2
for referencing.


Thanks.
Udo

[John Marshall, MVP]

Rather than discuss the details, can you explain what you want to achieve.

Do you want to create a shape that says "small" but when you stretch the
shape beyond a certain size it says "big".

There are several ways of changing text, but it would be easier if we knew
what effect you were looking for.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
Visio Wishlist http://www.mvps.org/visio/wish_list.htm

Post by Udo Weik
Hello,
is it possible to reference a cell via a variable,
e. g. the reference of the cell is
Sheet.135!User.Test0
Now I want to define a variable, so that I can
e. g. use
Sheet.135!User.Test0
Sheet.135!User.Test1
Sheet.135!User.Test2
for referencing.
Thanks.
Udo