Option buttons inside frames within a userform disappear partially when scrolling

mhashim

New Member
Joined
Mar 25, 2015
Messages
1
I designed a Userform, that appears automatically when user opens the Excel file. It shows Questions as text labels and 4 option buttons and Checkboxs within a frame for each question. it's an exam (MCQs) form. I am facing the following problem: when i scroll down through the userform, the option buttons and checkboxs disappear, or incorrectly displayed, but they are there, so when you click on their locations to select them they appear!. The problem occurs mainly, when using 2 monitors (primary, secondary) and when i make the userform full screen.


my code is very long and complicated, but this is the part related to displaying the userform in full screen:

<code>Application.WindowsState=xlMaximized
With UserForm2
.Height = Application.UsableHeight
.Width = Application.UsableWidth - 15
End With
UserForm2.ScrollHeight=(120*nq)+120
UserForm2.ScrollBars=fmScrollBarsVertical
UserForm2.KeepScrollBarsVisible=fmScrollBarsVertical
UserForm2.Zoom=130
UserForm2.Show vbModeless
Application.Visible=True</code>

I also tried different ways to make the userform full screen, one of them for example using the active window height and width. but i got same result. Please note that this file excel (userform) must be distrubuted to students, and they run on their own computers, so any solution must consider that.
Regards,
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,399
Latest member
alchavar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top