Hi Guys,

Can anybody help me to write up a formula/VB Code to generate a number which will display a number from 1 to 10 every 30 seconds ?
number should display in ascending order at a time, which will change to next after 30 seconds.

Regards
Dilan