Chiroman
06-08-2015, 11:08 AM
Hi,
I'm a chiropractor with just enough VBA knowledge to attempt a project to make report writing easier by having a huge userform where the doctor will input patients' information and the program will create the report in a Word document. I've have overcome many barriers with the help of nice posters (on a different forum) but I am stuck on what seems like a simple issue. My userform won't scroll down past 570, even though the design form Height is set to 1500 and the ScrollHeight is set to 3000. ScrollBars is set to 2-frmScrollBarsVertical. I can't progress any further in the project since the controls that I want to make functional can't be accessed in runtime. What makes this problem all the more frustrating is that the userform used to scroll down to 3000 no problem, but suddenly stopped working. I've researched my other forum, here and the internet and have seen no solution, or even the exact problem. I didn't get any help from the other forum (posted 2 weeks ago) so I decided to try here. Any help would be much appreciated. Thank you in advance!
I'm a chiropractor with just enough VBA knowledge to attempt a project to make report writing easier by having a huge userform where the doctor will input patients' information and the program will create the report in a Word document. I've have overcome many barriers with the help of nice posters (on a different forum) but I am stuck on what seems like a simple issue. My userform won't scroll down past 570, even though the design form Height is set to 1500 and the ScrollHeight is set to 3000. ScrollBars is set to 2-frmScrollBarsVertical. I can't progress any further in the project since the controls that I want to make functional can't be accessed in runtime. What makes this problem all the more frustrating is that the userform used to scroll down to 3000 no problem, but suddenly stopped working. I've researched my other forum, here and the internet and have seen no solution, or even the exact problem. I didn't get any help from the other forum (posted 2 weeks ago) so I decided to try here. Any help would be much appreciated. Thank you in advance!