MrExcel Publishing
Your One Stop for Excel Tips & Solutions

interactive macro


Posted by Della Barkley on December 14, 2001 9:58 PM

Hi .. I need to run a macro that will start the EDIT/FIND dialog box .. let the user enter the data to be found .. then close by itself after the data is found. I think that what I need is the VB code to stop the macro and start it again after user entry but cannot find this anywhere. help would be appreciated.
Della Barkley


Posted by Polixenes on December 14, 2001 11:06 PM

Application.Dialogs(xlDialogFormulaFind).Show