Moving A Frame Within a Form Based on Event

%3CLINGO-SUB%20id%3D%22lingo-sub-566525%22%20slang%3D%22en-US%22%3EMoving%20A%20Frame%20Within%20a%20Form%20Based%20on%20Event%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-566525%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20userform%20(excel)%20with%20multiple%20check%20boxes.%26nbsp%3B%20I%20have%20my%20form%20setup%20so%20that%20it%20will%20expand%2Fshrink%20in%20size%20based%20on%20the%20t%2Ff%20value%20of%20the%20checkbox.%26nbsp%3B%20However%2C%20for%20each%20checkbox%20I%20have%20a%20corresponding%20frame%20with%20additional%20options%20that%20will%20become%20visible.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20I%20am%20trying%20to%20resolve%20is%20the%20dead%20space%20if%20checkbox%202%20is%20selected%20but%20not%20checkbox%201.%26nbsp%3B%20I%20would%20want%20the%20corresponding%20frame%20(frame2)%20to%20show%20up%20in%20the%20location%20that%20frame1%20is%20in.%26nbsp%3B%20So%20basically%2C%20how%20do%20I%20go%20about%20moving%20the%20placement%20of%20the%20frame%20around%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-566525%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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