Returning progressive values with an option button?

[bademployee]

Hi all

I'd love to know how to have excel return a pre-defines series of values in a progressive order.

i.e.



We use excel for creating quotes, and our contract number are pre-defined, so I was thinking of having a list of values (contract numbers) hidden and each time a sales rep hits the option button the next contract number on the list is returned.

Is this possible or is there a better way?

Any help would be appreciated.

Mark