Hi,

I write macros that that extract data from my company's database.
use the 'Edit-Replace' option in VB to change the dates that ar
programmed to extract the data as they occur several times within th
macro.

Is it possible to program a userform (or similar) to do this?

For example I don't really want my clients playing directly with th
macro. I hoped I could have a userform pop-up that said 'Find' (the
insert the date) and 'Replace' (they insert the new date!) and upo
clicking OK the macro is changed and run!

I can only do this to use the 'Edit-Replace' option within Exce
rather than VBA

Any suggestions greatly recieved

Kate
Pool

--
Message posted from http://www.ExcelForum.com