LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making COUNTIF update in real time Bishop Excel Worksheet Functions 4 March 18th 09 10:03 AM
use date formula to update workbook in real time Michael Excel Worksheet Functions 1 January 8th 09 11:31 AM
Real-time update of chart using a Spin Button BinaryD Charts and Charting in Excel 4 November 7th 07 03:24 PM
Show real time in Userform caption Henrich Excel Programming 0 July 13th 06 04:26 PM
how to roll/scroll/log (??) real-time data ? joni Excel Programming 2 August 18th 04 10:15 PM


All times are GMT +1. The time now is 06:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"