Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"next and "previous"button problem in vba
Hi experts,
I have a problem after using autofilter. After useing autofilter i use the following code for going to the next or previous records next record code: Private Sub but_next_Click() Do Set filterrange = filterrange.Offset(1, 0) Loop While filterrange.EntireRow.Hidden = True Call textboxen_vullen 'code to fill a lot of textboxes End Sub previous record code: Private Sub but_next_Click() Do Set filterrange = filterrange.Offset(-1, 0) Loop While filterrange.EntireRow.Hidden = True Call textboxen_vullen 'code to fill a lot of textboxes End Sub The problem is that there is no limit. If i click previous enough times, i get an error message. I would like it to stop at the first record of the filtered set Also if i click the "next"button i want it to stop at the last record of the filtered list Can you please help me with this ? Thanks, Pierre |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"next and "previous"button problem in vba
On Jan 7, 2:09 pm, "Pierre" wrote:
Hi experts, I have a problem after using autofilter. After useing autofilter i use the following code for going to the next or previous records next record code: Private Sub but_next_Click() Do Set filterrange = filterrange.Offset(1, 0) Loop While filterrange.EntireRow.Hidden = True Call textboxen_vullen 'code to fill a lot of textboxes End Sub previous record code: Private Sub but_next_Click() Do Set filterrange = filterrange.Offset(-1, 0) Loop While filterrange.EntireRow.Hidden = True Call textboxen_vullen 'code to fill a lot of textboxes End Sub The problem is that there is no limit. If i click previous enough times, i get an error message. I would like it to stop at the first record of the filtered set Also if i click the "next"button i want it to stop at the last record of the filtered list Can you please help me with this ? Thanks, Pierre It looks like filterrange is defined outside of the listed subroutines. If you know the first and last row of filterrange prior to coming into the subroutines you could compare the row number of the 'next' row to see that it is between the first and last row. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |