Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaing Font with formulas | New Users to Excel | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
Protecting cells but maintaing data groups | Excel Discussion (Misc queries) | |||
sorting linked columns across worksheets, maintaing row integrity | Excel Discussion (Misc queries) | |||
Maintaing formula links when sorting | Excel Discussion (Misc queries) |