I created a "dynamic" userform based off of some code that i found on the internet. I seem to have it working.
Let me tell you kinda what it does and then explain my issue.
The user indentifies how many Quizes and problems per quiz. I then show the userform to get the possible points per problem. The issue is that IF the user wants say 3 quizes with say 12 questions/problems per quiz then the userform height is too large for the screen.
I did activate the scroll bar for the userform and as long as i go into the properties of the userform and set the scrollbar properties to the following then things work ok.
Keepscrollbarsvisible = 2
scrollbars = 2
scrollheigh = 10000
The problem is that for a scrollheight > than userform height i think it will work ok. However, if i use scrollheight of 10000 this means there will be a lot of "unpopulate" space at the bottom of the userform. I was thinking that if i could also update the scrollheight based on what the userform height is that i could get rid of this "unpoplulated" space.
Does this make sense?
Bookmarks