Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by berry456456
-
how to scroll spreadsheet while my userform is still on
Thank you so much, DaveInIowa and NWBeaver. That's very helpful and clear. Hope both of you have a wondful day!- berry456456
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
how to scroll spreadsheet while my userform is still on
Thank you all very much! Actually, I still have some questions: To NWBeaver: I tried in coding like: Userform.showmodal=false and it does not work. Is that true you can only set this properity manualy? To DaveInIowa: I tries this code: Application.Goto Reference:=myRange, Scroll:=True my...- berry456456
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
how to scroll spreadsheet while my userform is still on
I worte a Macro for search in my spreadsheet. So i designed a userform with a listbox. If you choose an item from the listbox and click "OK" commandbutton, the data line in the spreadsheet for that item will be selected. But now i can not scroll the bar in the spreadsheet. How can scroll...- berry456456
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
