edit/find menu in a macro

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I wan to display the find dialog box for text strings
within my work sheet in my macro,or can i link a message
box with the "what" in find
 
In your code, before the Find statement, insert:

fwhat = inputbox("String to find")

and then use variable fwhat as the What argument in find.

HTH,
Nikos
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel wait for Find Replace dialog box in Word 4
How to pen the Find dialog box with a macro 2
Using macros to open a file with the Find Menu option available 5
write a macro to show the edit.find dialog box in excel 1
Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to generate powerpoint slides 43
Macro search text boxes 5
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0

Back
Top