Disable events in userform

Hi Joe

Have you tried the Application.EnableEvents property?

JFS

JFS at 2007-8-30 >

Hello Joe,

I was a bit curious and tried the following:

Private Sub CommandButton1_Click()
MsgBox ("Command Click")
UserForm1.ScrollBar1.Width = 20
UserForm1.ScrollBar1.Max = 100
End Sub

Private Sub ScrollBar1_Change()
MsgBox ("In Scroll Bar Change")
End Sub

Private Sub UserForm_Initialize()
MsgBox ("In Initialise")
UserForm1.ScrollBar1.Max = 15
End Sub

The only time the ScrollBar_Change event is triggered is if I clicked on the scroll bar, or the up/down arrows of the scroll bar. The command button routine changes the width and max value and the scroll bar change was not triggered.

Chas

ChasAA at 2007-8-30 >

Hello Joe,

I am using Excel 2003. I tried it again today and it is still working.

In Tools - References

There are the usual 4

Visual Basic for Applications

Microsoft Excel 11.0 Objectr Library

OLE Automation

Microsoft Office 11.0 Object Library.

There is one other:

Microsoft Forms 2.0 Object Library

Try referencing these and see if it helps

Chas

ChasAA at 2007-8-30 >

Can you try the macro on another PC.

Sorry this is not a very good answer, or can you send me your sheet and I'll try it on my PC.

My email is charleschand@aol.com

Chas

ChasAA at 2007-8-30 >