Thread: Adjust userform layout based on combobox selection
View Single Post
 
Old 09-16-2018, 06:47 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
I would recommend you put the context specific content into a MultiPage tab control. Then you can show/hide the tabs to enable/disable chunks. This tends to work more simply than varying the tops/heights of things. It also provides a bit of safety since text boxes out of sight are still part of the tab order (unless also disabled) so the user might tab into one without seeing it on the form.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote