LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy contents of Find (Find and Replace) rob_bob Excel Discussion (Misc queries) 0 March 26th 09 11:01 PM
Interactive course pepenacho New Users to Excel 1 July 16th 07 10:23 AM
Interactive Workbook Ryan Excel Discussion (Misc queries) 0 June 29th 07 08:48 PM
iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB kathy in kansas Excel Discussion (Misc queries) 0 January 24th 05 07:47 PM
interactive vba Hervé Hanuise Excel Programming 1 October 8th 03 05:49 PM


All times are GMT +1. The time now is 06:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"