What did I do to the scroll bars in my UserForms?

[aeroned]

I was messing around with a calendar form and all of the scroll bars in all of my userforms, several different spreadsheets, stopped working. The "sliders" can't be grabbed and moved and the mouse wheel no longer scrolls. It's only in UserForms, the scrolling in spreadsheets works fine. I've tried restarting with no luck. Could it be some Excel program setting?

Any help will be appreciated.

Ned

 

[Logit]

.
Whenever something like that happens to me it is due to me making a change on a workbook and not resetting that change back to "normal" when closing the workbook.
So the change then affects every workbook opened afterwards.

You will need to think back to find the workbook you were 'experimenting' with where a basic layout change was implemented.

You can also check the Excel Option Settings but I don't recall there being adjustments to the FORMS settings.

 

[aeroned]

I'm really lost. I uninstalled/reinstalled Office no luck.
I've tried to make new form with new comboboxes, the scroll bar doesn't work. I can't even click on the slider and drag it. The list only moves by clicking the arrows or the space above or below the slider.

 

[Logit]

.
If you still retained the existing workbook/s that were there prior to and after re-installing Office, I believe the settings wouldn't be adjusted because the settings are actually in the workbook
itself and not Office.

If you create a new workbook after re-installing Office are the same issues showing up ?

 

[aeroned]

OK the new combobox in a new userform in a new workbook worked. The scroll wheel even works, everything is back to normal.

Even the old userform in the old workbook works. Wow!! that was weird. Thank you very much for the help!

 

[Logit]

.
Guess you had a VBA Gremlin running about your machine. I get them from time to time as well.

Cheers.

 

[My Aswer Is This]

I have one of those Gremlins. Every time I launch Excel. Excel Startups but does not display a new Workbook. I always have to press Ctrl N to open a New Workbook.

.
Guess you had a VBA Gremlin running about your machine. I get them from time to time as well.

Cheers.

 

[Logit]

Maybe ..... its really an undocumented M$ add-on feature ?