Re: Slider bar continues to increment when mouse hovers over arrow

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

John,

That sho'nuff sounds like a bug. Perhaps you could use a scroll bar from the Control
Toolbox instead. It has a cell link, like the one from the Forms Toolbar.
--
Earl Kiosterud
www.smokeylake.com

Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

-----------------------------------------------------------------------
"John Broderick" <none@xxxxxxxx> wrote in message
news:%23xzeGNQiHHA.4772@xxxxxxxxxxxxxxxxxxxxxxx
Earl,

thanks for the reply.

You are correct in that I mean a scrollbar.
It is not a problem with the mouse button hardware being stuck.

If I switch to manual calulation the problem goes away. The scrollbar
functions normally.

If the Scrollbar is linked to a cell that does not force a big table
recalcuation there is no issue with the Scrollbar.
It is just when the linked cell causes a long recalculation that the
scrollbar misbehaves.
Yes the slider moves, and the linked cell increments in both manual and
autocalculate mode.

I think the problem is only seen in Autocalculation mode, when the sheet
takes a long time to recalculate (due to the large table).
I think Excel somehow mistakenly thinks the scrollbar arrow is being
repeatedly clicked (even though the mouse pointer is really
just hovering over the arrow rather than clicking on it) while it is busy
recalculating the table.
If you didn't have a recaluation time of 2-3 seconds you might not see the
problem.


John

"Earl Kiosterud" <someone@xxxxxxxxxxx> wrote in message
news:e0ivv7PiHHA.4676@xxxxxxxxxxxxxxxxxxxxxxx
John,

I think you're referring to a scrollbar. It isn't normal behaviour for it
to keep changing
while the mouse hovers over it. I just tested to be sure (XL2003). If
your mouse button is
sticking down, you'd get that behaviour. If you click a cell, then move
to other cells, do
they all select (as if the button is stuck down)?

With the scroll bar, does the slider move? Does the linked cell
increment? Have you tried
creating another to see if it behaves the same? Try that in a new
workbook.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting. But if you bottom-post to a reply
that's already
top-posted, the thread gets messy. When in Rome.

-----------------------------------------------------------------------
"John Broderick" <none@xxxxxxxx> wrote in message
news:eGeuWoNiHHA.1216@xxxxxxxxxxxxxxxxxxxxxxx
I am using a slider control from the forms toolbar.
I also have a data table setup on my sheet and I view the results in a
graph..

My problem concerns the behavior of the slider bar in Automatic
calculation
mode.
If I click (and release) once on the slider arrow the slider increments
by
one, but then continues incrementing as long as the mouse pointer hovers
over the slider arrow (even though I click and release no more than
once).
I just want it to increment one unit for one click and release,
recalculate
and let me see the results on a graph, then I may click again to
increment
one more and see the results again.

Is there a way to fix this?

Thanks
John








.

Relevant Pages

  • Re: TableCellEditor Questions
    ... > I'm trying to create a table cell editor for a JTable that displays a cell ... > circumstances for a renderer to display a working horizontal scrollbar? ... and I don't see a reason why a JScrollPane will not scroll by itself. ...
    (comp.lang.java.gui)
  • Re: Linking Scrollbar Min and Max values to worksheet cells
    ... I am not a Controls expert, ... I used cell $A$1 for the minimum value of the scrollbar, ... I left the scrollbar named as "ScrollBar1". ... Dim rngScrollMin As Range 'Cell that contains Scrollbar minimum. ...
    (microsoft.public.excel.programming)
  • TableCellEditor Questions
    ... I'm trying to create a table cell editor for a JTable that displays a cell ... circumstances for a renderer to display a working horizontal scrollbar? ... listener on the scrollpane (my TableCellEditor extends JScrollpane) OR on ... if anyone can point me to additional online tutorials on editors ...
    (comp.lang.java.gui)
  • Excel VBA Userforms - especially check boxes
    ... *There have been 3 homework assignments. ... If I tick a checkbox I want Excel to put TRUE in the ... corresponding cell. ... scrollbar as I drag it. ...
    (microsoft.public.excel.programming)
  • Re: scroll bar on chart disappears
    ... After adding the scroll bar to the chart, I had to change its location to a chart sheet for the scroll bar to work. ... you activate the chart, it hides the scrollbar. ... Since the scrollbar refers to a cell, if I click on the cell the scrollbar re-appears on the chart and I can use it to change my charting range. ...
    (microsoft.public.excel.charting)