Jim,

There are two answers to the scroll bar blink question here...
http://makeashorterlink.com/?L614233FB

Regards,
Jim Cone
San Francisco, USA


"Jim May" wrote in message
news:9Fb2f.3074$jw6.974@lakeread02...
I've cloned the procedure offered in WROX Excel 2002 VBA - Programmer's
Ref - Page 243-247 - and it is working at a 95% level..
(The set of macros enables a Userform to Scroll the records and useCommand
buttons Next Record and Previous Record. The underlying data is
assigned to a range named Database. A minor annoyance at this point is that
the scrollbar mid-bar is "blinking" once I activate it; I'd like to
not have this "Blink" On and Off - but how? -- my test database (at this
point only has 4 rows and 3 records) - with scrollbar value = 2 and min = 2
max=32276. As I scroll through the records (single-view of each) I also
have a command button:

Private Sub cmdApprvRec_Click()
MyRow = rgData.Row '<< represents the Current record
Worksheets("Incoming").Cells(MyRow, 19).Value = "Approved"
End Sub

The above code Changes, let's say cell S4 from "Released" to "Approved"
after clicking on the button (as I want it to), but as soon as I change to
another record cell S4
reverts back to "Released" -- where I need it to remain "Approved".

Any thoughts on what action to take here?
Thanks in Advance..
Jim May