Thanks Barb,
I put the custom format in A1 but the problem is that when you change x to a
number it doesn't work. You need to erase everything inside A1 and type in
the number for it to work. I'm sorry if this doesn't make sense, I'll try to
explain again: A1 should look like this "Week x" originally. The user should
be able to change x into a number and then A1 should display "Week 2" if the
user chose 2. A2 should display "Next Week (3)"

"Barb Reinhardt" wrote:

You could put a custom format on A1 as well and that would resolve that issue.

"NOOBY92" wrote:

The problem with your solution (correct me if I'm wrong) is that A1 has other
characters besides the variable (x). So A1 will never be blank. That is why I
want to be able to make a character (x) a variable.

"Barb Reinhardt" wrote:

You don't really need VBA to do what you want.

Did you try this in A2 ?

Format - Cells - Custom

"Next Week ("0")"

In A2, put this:

A2: =IF(ISBLANK(A1),"",A1+1)

If you want a VBA solution, come back and let us know.


"NOOBY92" wrote:

Hello, I am completley new to Visual Basic. I have XP SP2 and Excel 2002 Here
is what I need.

I want to make a regular character (for example "x") a variable.
Then I want to use that variable in other cells.
For Example.

Cell A1- Week x /I want to make x a variable/
Cell A2- Next Week (Week ) /I want "x+1" to appear after "(Week " but I
don't want anything to appear after "(Week " until the value for X is
determined/


Thank You Very Much