Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Making COUNTIF update in real time | Excel Worksheet Functions | |||
use date formula to update workbook in real time | Excel Worksheet Functions | |||
Real-time update of chart using a Spin Button | Charts and Charting in Excel | |||
Show real time in Userform caption | Excel Programming | |||
how to roll/scroll/log (??) real-time data ? | Excel Programming |