Help filling boxes with color

[nutrageousd]

Hello,

This is only my 2nd post here and I need your help.

Can anybody suggest a way to use VBA code or something to Fill boxes and display % of boxes filled as well? I want to use this for people to track progress of projects, and i want them to be able to just push forward and back buttons to fill/unfill bars until they are done with their project. Any suggestions? Thanks in advance!

 

[Tom Urtis]

You should clarify what the word "boxes" means to you.

TextBoxes?
If so, from the forms toolbar or control toolbox?

ComboBoxes?
If so, from the forms toolbar or control toolbox?

ListBoxes?
If so, from the forms toolbar or control toolbox?

CheckBoxes?
If so, from the forms toolbar or control toolbox?

Drawing shapes?

Cells?

Some other object not named above?

It seems that if you want progress tracked, you should display the percentage not as filled "boxes" (though you can fill them if you want), but rather based on a more reliable criteria, such as all cells or fields entered into, or maybe the word "Complete" in a field (column) for that purpose.

 

[nutrageousd]

Sorry i wasn't clear on what I meant.

I want the cells to be filled with color along with the % displayed in another cell. I want to have something like 10 cells, and as they push the "up" or "forward" button it fills one cell, and displays 10%...20%...etc. Thanks again