Hello I'm working with VBA code in MS Excel from Office 95.

Does anyone know how to get a vba macro code to remember the last value
entered into an input box?

I have this code:

Sub search_open_books()
    Message = "Enter search term: "
    Title = "Search 3 sheets inputbox"
    myfind = InputBox(Message, Title)
    Cells.Find(myfind, matchCase:=False).Activate
    ActiveWindow.ActivateNext
    Cells.Find(myfind, matchCase:=False).Activate
    ActiveWindow.ActivateNext
    Cells.Find(myfind, matchCase:=False).Activate
End Sub

Currently this code stops at the first occurence of 'myfind'.  Can I
either get it to go through all sheets or remember the value entered the
last time?

Thanks.