Moving A Frame Within a Form Based on Event

Occasional Visitor

Hello All,

 

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? 

 

Thanks in advance!

0 Replies