PDA

View Full Version : Solved: VBA - form/workbook problem



kakaruzas
08-07-2009, 01:56 AM
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!
:beerchug:

mdmackillop
08-07-2009, 03:21 AM
You need to open the form Non-Modally
The code line is

Userform1.Show False

kakaruzas
08-07-2009, 03:43 AM
Thank you for your answer!
I didn't find the .open function but I used .showmodal one. Thanks again for your help!

mdmackillop
08-07-2009, 03:51 AM
Ooops! "Show" is correct, I've amended my post.

BTW, Welcome to VBAX.