Stargazer
09-10-2013, 04:12 AM
Hiya,
This feel like almost the most ridiculous question, but it has really flummoxed me...
I'm building a simple UI on a userform in Excel2007. The Userform sits at the bottom of the screen so that the user can input data into it and still have the data visible above it.
Near the bottom edge fo the userform is a ComboBox. The list is 8 items long, but I only see the top 3 because the list expands out of the boundaries of the application/screen.
Is there a toggle or something I can do to make the list expand upwards instead of downwards if the screen boundaries do not permit the entire list to be seen? Or is this a hole in Excel and the userform needs to be redesigned to keep ComboBoxes higher up?
Many thanks in advance,
Rob.
This feel like almost the most ridiculous question, but it has really flummoxed me...
I'm building a simple UI on a userform in Excel2007. The Userform sits at the bottom of the screen so that the user can input data into it and still have the data visible above it.
Near the bottom edge fo the userform is a ComboBox. The list is 8 items long, but I only see the top 3 because the list expands out of the boundaries of the application/screen.
Is there a toggle or something I can do to make the list expand upwards instead of downwards if the screen boundaries do not permit the entire list to be seen? Or is this a hole in Excel and the userform needs to be redesigned to keep ComboBoxes higher up?
Many thanks in advance,
Rob.