-
Solved: VBA - form/workbook problem
Hello there!
I am quite new with VBA, started working with it just month ago. I made up this little excel file with buttons and so on which calls upon another workbook. When the other workbook opens a form appears which lets navigate through the sheets more easily. However, the main problem is that I sometimes need to scroll the sheets and I can't do it without closing the form. Are there any solutions?
Also, if it was possible to do the first task, would it be possible to still make the form to be on top?
Big thanks in advance!
Last edited by kakaruzas; 08-07-2009 at 03:18 AM.
-
You need to open the form Non-Modally
The code line is
[vba]
Userform1.Show False
[/vba]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
Thank you for your answer!
I didn't find the .open function but I used .showmodal one. Thanks again for your help!
-
Ooops! "Show" is correct, I've amended my post.
BTW, Welcome to VBAX.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules