
VBA In MS Excel from Office 95.
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.