Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive Find and Copy
I would like to create a macro that will ask the user for a string, find the
first occurrence in a range and then ask the user if the find is correct. If the find is correct I want to copy the cell to the left of the find back into the cell from which the find was initiated. If the find is incorrect I would like to search for the next occurrence of the string and then ask again. If the sting is not found I would like the cursor to return to the orignial cell from which the find was initiated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive Find and Copy
I would recommend using the macro recorder, vbYesNo in the message box,
inputbox, and the Find and FindNext methods. Someone might be up to the task of creating this for you, but it shouldn't be too hard using these tools to create what you want. Good luck! -- -SA "Glory2God" wrote: I would like to create a macro that will ask the user for a string, find the first occurrence in a range and then ask the user if the find is correct. If the find is correct I want to copy the cell to the left of the find back into the cell from which the find was initiated. If the find is incorrect I would like to search for the next occurrence of the string and then ask again. If the sting is not found I would like the cursor to return to the orignial cell from which the find was initiated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interactive Find and Copy
I was really hoping that someone could help me out with the code. I am not
that good with VBA but have usually been able to adapt another's solution to mine and, in this case, I can't seem to pull it off. I currently am trying to use a "select the cell" when the first find does not produce the correct result. Unfortunatly that one is producing one undesired result that I can't see to fix. Can you help? "StumpedAgain" wrote: I would recommend using the macro recorder, vbYesNo in the message box, inputbox, and the Find and FindNext methods. Someone might be up to the task of creating this for you, but it shouldn't be too hard using these tools to create what you want. Good luck! -- -SA "Glory2God" wrote: I would like to create a macro that will ask the user for a string, find the first occurrence in a range and then ask the user if the find is correct. If the find is correct I want to copy the cell to the left of the find back into the cell from which the find was initiated. If the find is incorrect I would like to search for the next occurrence of the string and then ask again. If the sting is not found I would like the cursor to return to the orignial cell from which the find was initiated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy contents of Find (Find and Replace) | Excel Discussion (Misc queries) | |||
Interactive course | New Users to Excel | |||
Interactive Workbook | Excel Discussion (Misc queries) | |||
iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB | Excel Discussion (Misc queries) | |||
interactive vba | Excel Programming |