I have a UserForm that has several "extra" checkboxes. These checkboxes are enabled in some scenarios, but I use an IF statement to hide them most of the time, based on what is going on in the worksheet.
I have the checkboxes functioning properly, but because hiding them leaves a lot of empty space on the UserForm, I want to add to the same IF statement, to shift CommandButton1 & 2 up to a predetermined location (overtop of where the hidden checkboxes are hiding), and also to shorten the overall height of the UserForm by a similar amount.
I researched this a long time ago to see if it was possible, and now I can't figure out how to do it, and I can't find whatever I referenced on my first search. Thanks!
I have the checkboxes functioning properly, but because hiding them leaves a lot of empty space on the UserForm, I want to add to the same IF statement, to shift CommandButton1 & 2 up to a predetermined location (overtop of where the hidden checkboxes are hiding), and also to shorten the overall height of the UserForm by a similar amount.
I researched this a long time ago to see if it was possible, and now I can't figure out how to do it, and I can't find whatever I referenced on my first search. Thanks!