Hi,
During form initialization, I want to set values of certian check marks
based on what columns are hidden in a workbook.

The checkmark_Click routine has code but I don't want to run it when I
assign the value on ititialization.

Is there a way to do this?
I tried chkMark.value and also tried disableing events but that didn't work
either.

Any help would be appreciated.

Thanks,
MikeZz

If you really disabled events, how did the checkmark_Click event fire ?

Something wrong with your code I suspect.

NickHK

"MikeZz" <(E-Mail Removed)> wrote in message
news:7382F6C9-A97C-4127-B6A1-(E-Mail Removed)...
> Hi,
> During form initialization, I want to set values of certian check marks
> based on what columns are hidden in a workbook.
>
> The checkmark_Click routine has code but I don't want to run it when I
> assign the value on ititialization.
>
> Is there a way to do this?
> I tried chkMark.value and also tried disableing events but that didn't
work
> either.
>
> Any help would be appreciated.
>
> Thanks,
> MikeZz

Hi Mike,

The EnableEvents property ha no effect on
Userform events.

Try using a module level variable selectively to
disable the event(s) of interest.

For example, try:

'=============>>
Option Explicit

Private blDisable As Boolean

'------------------>>
Private Sub UserForm_Initialize()
blDisable = True
Me.CheckBox1.Value = True
blDisable = False
End Sub

'------------------>>
Private Sub CheckBox1_Click()
If blDisable Then
Exit Sub
End If
'your code, e.g.:
MsgBox "Hi"
End Sub
'<<=============



---
Regards,
Norman


"MikeZz" <(E-Mail Removed)> wrote in message
news:7382F6C9-A97C-4127-B6A1-(E-Mail Removed)...
> Hi,
> During form initialization, I want to set values of certian check marks
> based on what columns are hidden in a workbook.
>
> The checkmark_Click routine has code but I don't want to run it when I
> assign the value on ititialization.
>
> Is there a way to do this?
> I tried chkMark.value and also tried disableing events but that didn't
> work
> either.
>
> Any help would be appreciated.
>
> Thanks,
> MikeZz