Link to home
Start Free TrialLog in
Avatar of Bright01
Bright01Flag for United States of America

asked on

Problem with Floating Form

Byundt helped me with a Macro that allowed the creation of a floating option box by calling a Form.  In the sample he sent me, it worked perfectly and we closed out the Question.  When I put it into my production file, the form worked but when I put the cursor in any cell, I could not "scroll".  I believe the reason may have something to do with the fact that my production file has a 4 level outline.

Take the file attached, and click on "Select Detail". You will see the options and if you fire any of the buttons/macros, it works perfectly (collapsing and expanding the outline). BUT, you can't scroll.

Help!

B.
Problem-with-floating-Form.xlsm
Avatar of byundt
byundt
Flag of United States of America image

You didn't set the ShowModal property of the userform to False.

After making that change, the code should work.
SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can't scroll a worksheet when you are displaying a userform
That might be true in other languages, but you can definitely scroll the worksheet in Excel while displaying a modeless userform.
Avatar of Bright01

ASKER

Wow....thanks guys!  Lots of options here..... I changed the Modal to "False" and added Brundt's code.

Nice "tweak".
I stand corrected.