-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA scroll bar not working on the second screen
- Thread starter rb225
- Start date
Jimmypop
Well-known Member
- Joined
- Sep 12, 2013
- Messages
- 753
- Office Version
- 365
- Platform
- Windows
Hi there
It sounds like you may be encountering a known issue with VBA userforms on multiple monitors where the scroll bar becomes unresponsive when the VBA application is opened on a secondary monitor.
One potential solution to this issue is to use the following code in the UserForm_Initialize event:
This code explicitly sets the userform's scrollbar property to vertical and may help to resolve the issue. Alternatively, you could try to move the VBA application to the primary monitor before opening the userform. This may help to avoid the issue altogether. If neither of these solutions work, you may need to explore other potential causes for the scroll bar issue, such as conflicts with other software or hardware on your system.
It sounds like you may be encountering a known issue with VBA userforms on multiple monitors where the scroll bar becomes unresponsive when the VBA application is opened on a secondary monitor.
One potential solution to this issue is to use the following code in the UserForm_Initialize event:
VBA Code:
Me.ScrollBars = fmScrollBarsVerticalThis code explicitly sets the userform's scrollbar property to vertical and may help to resolve the issue. Alternatively, you could try to move the VBA application to the primary monitor before opening the userform. This may help to avoid the issue altogether. If neither of these solutions work, you may need to explore other potential causes for the scroll bar issue, such as conflicts with other software or hardware on your system.
Upvote
0
