I have a userform (excel) with multiple check boxes. I have my form setup so that it will expand/shrink in size based on the t/f value of the checkbox. However, for each checkbox I have a corresponding frame with additional options that will become visible.
The problem I am trying to resolve is the dead space if checkbox 2 is selected but not checkbox 1. I would want the corresponding frame (frame2) to show up in the location that frame1 is in. So basically, how do I go about moving the placement of the frame around?