Good morning, I am trying to write code and am very new to VBA. I created a pop-up box with a message upon opening an excel
file. I want the user to be able to click on yes or no and upon yes I would like the find (search tool) to appear.
Can anyone help?
Here is what I have so far...any suggestions on formatting the pop-up box are appreciated
MsgBox "To search for a specific keyword please use the find function (Ctrl F)" & Chr(10) & "Type
your keyword and press Enter" & Chr(10) & "Continuing to press enter will move you through the entire
worksheet one recurrence at a time." & Chr(10) & "Would you like the search tool?", vbYesNo