[Solved] How do I use a combobox and textbox on a userform in VBA to search and find data on the active Excel spreadsheet?
So her is a new Solution. You have to declare 3 Public Variables in the UserForm1 Modul. So you can give them Values while the USerForm is open and Find the Naxt Values when you click multiple Times on the Search Button. ‘Public Variables Public bolFirstSearch As Boolean Public rng As Excel.Range Public cellFound As … Read more