Bright01
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can't scroll a worksheet when you are displaying a userformThat might be true in other languages, but you can definitely scroll the worksheet in Excel while displaying a modeless userform.
ASKER
Wow....thanks guys! Lots of options here..... I changed the Modal to "False" and added Brundt's code.
Nice "tweak".
Nice "tweak".
I stand corrected.
After making that change, the code should work.