Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Next is not working for me.......
I am trying to build a userform that allows a user to enter a search
string and click a button I have named "Find". This works fine. I have created a second button on the user form and have titled it "Find Next". I want the user to be able to click this button and search for a second occurrence of the original string. I have looked at numerous examples of the FindNext method and have noticed that they are all in the same subroutine. I am trying to have two separate buttons with their own subroutines. I am not having any luck making this work. Help...... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Next is not working for me.......
In the grander shceme of things you are not really doing a find next. You are
just doing a find looking after the instance you have just found. Your find next code should just use the find function and specify the cell that you have just found as the starting point for your next seach... -- HTH... Jim Thomlinson "Tom" wrote: I am trying to build a userform that allows a user to enter a search string and click a button I have named "Find". This works fine. I have created a second button on the user form and have titled it "Find Next". I want the user to be able to click this button and search for a second occurrence of the original string. I have looked at numerous examples of the FindNext method and have noticed that they are all in the same subroutine. I am trying to have two separate buttons with their own subroutines. I am not having any luck making this work. Help...... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Next is not working for me.......
Sorry to be exact you should specify the cell immediately after the one you
just found as the starting point, not the cell you just found... Assuming that you are selecting the cell then it would be LookAfter:=activecell.offset(1,0) or something similar depending on whether you are looking up or down or by rows or by columns... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: In the grander shceme of things you are not really doing a find next. You are just doing a find looking after the instance you have just found. Your find next code should just use the find function and specify the cell that you have just found as the starting point for your next seach... -- HTH... Jim Thomlinson "Tom" wrote: I am trying to build a userform that allows a user to enter a search string and click a button I have named "Find". This works fine. I have created a second button on the user form and have titled it "Find Next". I want the user to be able to click this button and search for a second occurrence of the original string. I have looked at numerous examples of the FindNext method and have noticed that they are all in the same subroutine. I am trying to have two separate buttons with their own subroutines. I am not having any luck making this work. Help...... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Next is not working for me.......
That worked great. thx
Jim Thomlinson wrote: In the grander shceme of things you are not really doing a find next. You are just doing a find looking after the instance you have just found. Your find next code should just use the find function and specify the cell that you have just found as the starting point for your next seach... -- HTH... Jim Thomlinson "Tom" wrote: I am trying to build a userform that allows a user to enter a search string and click a button I have named "Find". This works fine. I have created a second button on the user form and have titled it "Find Next". I want the user to be able to click this button and search for a second occurrence of the original string. I have looked at numerous examples of the FindNext method and have noticed that they are all in the same subroutine. I am trying to have two separate buttons with their own subroutines. I am not having any luck making this work. Help...... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Next is not working for me.......
It's called LookAfter, because it looks after the range provided. Therefore
you don't need the offset. The range provided would be the last cell it looks at. -- Regards, Tom Ogilvy "Jim Thomlinson" wrote in message ... Sorry to be exact you should specify the cell immediately after the one you just found as the starting point, not the cell you just found... Assuming that you are selecting the cell then it would be LookAfter:=activecell.offset(1,0) or something similar depending on whether you are looking up or down or by rows or by columns... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: In the grander shceme of things you are not really doing a find next. You are just doing a find looking after the instance you have just found. Your find next code should just use the find function and specify the cell that you have just found as the starting point for your next seach... -- HTH... Jim Thomlinson "Tom" wrote: I am trying to build a userform that allows a user to enter a search string and click a button I have named "Find". This works fine. I have created a second button on the user form and have titled it "Find Next". I want the user to be able to click this button and search for a second occurrence of the original string. I have looked at numerous examples of the FindNext method and have noticed that they are all in the same subroutine. I am trying to have two separate buttons with their own subroutines. I am not having any luck making this work. Help...... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why code for find() is not working | Excel Discussion (Misc queries) | |||
Find all then paste not working. | Excel Programming | |||
Find Method Not Working Right ? | Excel Programming | |||
.Find method not working??? | Excel Programming | |||
Find value loop not working | Excel Programming |