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



Thu, 20 Jul 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. VBA for Excel and other Office '95 apps

2. VBA Excel 7.0 (Office 95) Sources.

3. VBA for Office 95 vs Office 97

4. MS Office 95 Spell Checker and VB4

5. Wanted: Combobox with directory tree-list (as in MS Office 95)

6. Accessing MS-Office 95 builtin document properties with VB

7. Coding data Export from Crosstab Query to Excel (Office 95)

8. Coding Data Transfer from Access to Excel (Office 95)

9. Access 95 and (Excel 97 and Excel 95)

10. Office Developer's Kit for Office 95

11. Question on old version of VBA for Excel 95

12. Creating Class in VBA of Excel 95

 

 
Powered by phpBB® Forum Software