hi all, I have a userform, within the form I have about 20 textboxes, I have set the userform to have a vertical scrollbar, but it does not seem to work,
any ideas?
scouse13
hi all, I have a userform, within the form I have about 20 textboxes, I have set the userform to have a vertical scrollbar, but it does not seem to work,
any ideas?
scouse13
Did you add the scrollbar from the tools? If so, remove it then do this..
In the VBA editor window -
Click on the UserForm
in the UserForm Properties window -
Set ScrollBars to 2
ScrollTop to 0
and ScrollHeight to a number that is larger than the height of the UserForm
So if the height of the userform is 100, change the ScrollHeight to 200
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
You're welcome. I did something similar last night. I worked on something for a few hours, couldn't get it figured out so I finally came on here to ask for help. Within minutes, bakerman2 posted a solution for me. I need to just start coming here right away lol.
I would change your location entry to your location, unless you want lots of SPAM in your inbox ...![]()
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I have removed your email from your profile. Please do not include personal information on a public forum like this.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins
It's still visible ...
I just refreshed and its not there?
Maybe it took a few minutes to take effect.
Gone now.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks