View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dim dim is offline
external usenet poster
 
Posts: 123
Default Userform Scroll Bar Doesn't Update in Real time ???

Hi folks,

I have a Scroll Bar in a UserForm and also a Label. The Scroll Bar is
controlling Cell B1 on my worksheet, which is formatted for numbers to zero
decimal places, and the Label also in my UserForm is Datalinked to Cell B1 to
display the spinners value. The spinner can display from 0 to 100.

When I run the form and move the spinner, the numbers in Cell B1 don't
change until after I click on a Userform element other than the spinner.
Obviously I need the numbers to change as the spinner is moved so I know what
number I'm at!

Here is a short video I did to show you my problem:

http://www.youtube.com/watch?v=mNa9W0AN0dE

Any ideas how to fix this?

Thanks for any advice...