Text box or Cell area updating

**munkee** · 12-11-2009, 06:19 AM

Hi,

I have two sheets in my workbook. One named singledump and the other individualfileselect.

Within single dump i have daily data loaded with certain cells containing comments added for that day of the week.

E.g. Tuesday 3000
Below average clearances, we will look in to this further throughout the week.

What i would like to do is have either a text box area of just simply one cell updating with a the first comment from the week and to then have two buttons back and forward allowing the user to click and the cells will update for the next comment that week or go back to the comment before.

How would i be best going about this? To be honest i would prefer to keep away from text boxes and would be happy with just the two buttons scrolling through specified ranges to update a cell on individualfileselect sheet.

Thanks for any help

**JeanRage** · 12-11-2009, 06:33 AM

Hi,

Could you please clarify what you mean exactly by "comment" ...
Ideally, you should post a sample file to explain your need ...

HTH

**Marzuk** · 12-11-2009, 06:36 AM

Try something like the sheet attached.

This uses a spin button, and increments / decrements a counter in a range, and index is used with a range to display text. This example has NO validation (so when someone clicks down too many times and goes to -22 for example.. yeah).

**munkee** · 12-11-2009, 06:42 AM

Thank you for the example marzuk ill be able to edit this to my needs quite easily.

How would i constrain the values the spinbutton can go through?

if i index monday as 1 tuesday as 2 etc up till friday 5 and then not allow to go over 5 or below 1?

or perhaps to just start cycling back through after 5 so it goes back to 1 after that.

**Marzuk** · 12-11-2009, 06:46 AM

You could do a variety of things to limit that. If for example the comment range was say from A1 to A100, when you implemented SpinUp() you could only increment if the resulting cell was not blank.

**munkee** · 12-11-2009, 06:53 AM

Bah hit a problem since im such a noob at all of this.

I can not get the index to work if the cells are offset (in my workbook i will have to specify the cells that contain the comments as there is other data between these.)