ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   edit/find menu in a macro (https://www.excelbanter.com/excel-programming/287557-edit-find-menu-macro.html)

Paul

edit/find menu in a macro
 
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

Nikos Yannacopoulos[_5_]

edit/find menu in a macro
 
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
-----Original Message-----
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
.



All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com