Forms - Scroll Bar or Spinner (Data in increments)

[Guest]

Hello All,

I'm a first time user of a form. I'd like to use the Scroll Bar, but two
problems:

1. It only allows whole numbers (I'd like to use %)
2. Max value is 30,000 (I'd like it to be higher)

Any thoughts?

TIA

 

[dominicb]

Good evening Jeff

I have always found spinners a little restrictive in using whole
numbers, (after all Excel uses them in places so why can't we?). You
don't have to actually place the spinner counter on screen, you could
link the spinner to a text box and display the result of the spinner
divided by 10 to get a decimal place in the text box - it's cheating
but it can be done.

Alternatively, set up two small buttons next to a text box, using
symbols from the wingdings character set as up and down arrows. Each
of these buttons needs a piece of code attached to increase or decrease
the value of the text box accordingly. You couldn't get this to look
exactly like the Excel equivalent, but you won't have any restrictions
and can format it how you please.

HTH

DominicB

 

[Guest]

I went with the first option and used a helper column..... Thanks.

 

[dominicb]

Hi Jeff.

Glad to help. Thanks for the feedback.

DominicB