I'm in the process of a new project & need some advice to help me get started. Hopefully I will explain the idea well enough, if not please let me know.
There will be 14 Rows & 9 Columns. Each row is relative, which I hope to explain further down.
A small diagram is attached (very brief & not full scale!) to give you an idea of what I have in mind.
Bonus - If one is selected it will highlight (amber) that row (Doesn't highlight the last cell. Disabling all the bonus 'optionbuttons'.
Low - If selected it will highlight that cell (not the row or column) in green & add a minus (-) to the end of the number (the number entered was 200, would then be 200-)
High - If selected it will highlight that cell (not the row or column) in green & add a plus (+) to the end of the number (the number entered was 200, would then be 200+)
Each cell in the same row is relative to all cells (apart from the final cell). If R1/C1 is 100 & is selected 'High', then R1/C2 would need to be greater then 100. Alert, if I tried to enter 99 or lower in R1/C2. Alert, If I tried to enter 99 or lower in R1/C7 etc.
The final Column (C9) is relative to the entire row. If a number is entered it will highlight that cell in red (not row or column). If R6/C9 is 800- then all cells in that row (R6) must be lower then 800. Alert, if I try to enter 799 or lower in any of the cells in R6.
Any idea's, suggestions & advice is much appreciated as I simply don't know how best to approach this project. I know some VB6, not much & its been a few months since I used it last.
Reply With Quote