Progress Bar & Cell Linking

[Xenoshan]

I am creating a character sheet for a pen and paper, online, rpg. I have
created the basic ouline but want to make a progress bar for the skills so
that I can keep up with how far along they are learning the current skill.
The problem is that I want to be fancy and want a progress bar linked to a
cell with the value of how far they are alo9ng (I.e. cell A1 has 35 in it,
the progress bar will show
{---35---}

How do i get the progress bar to link to a cell?
I am self taught but I took visual basic in college and they covered this
just a hair.
I am just now attempting to recover my thoughts from those years.

Can someone give me a bit of help with how to link the cells to a progress
chart?

 

[Jim Cone]

You can use a formula to show a simple bar whose length varies
depending on the value in a cell.
If the value 35 is in cell B5, then try this formula in C5...
=REPT("n",B5/2). Assign the Wingdings font to cell C5 and
adjust the font size. Customize as desired.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Xenoshan" <u22508@uwe>
wrote in message
I am creating a character sheet for a pen and paper, online, rpg. I have
created the basic ouline but want to make a progress bar for the skills so
that I can keep up with how far along they are learning the current skill.
The problem is that I want to be fancy and want a progress bar linked to a
cell with the value of how far they are alo9ng (I.e. cell A1 has 35 in it,
the progress bar will show {---35---}
How do i get the progress bar to link to a cell?
I am self taught but I took visual basic in college and they covered this
just a hair.
I am just now attempting to recover my thoughts from those years.
Can someone give me a bit of help with how to link the cells to a progress
chart?