Redefine UserForm CheckBox Click Action

[mike_302]

I have a UserForm that comes up when I click a tab. For my own unique reasons, I need to define what happens on the CheckBox_Click function, before the Form is called -- the Action will be dependent on the outer If statement I've programmed (see below). It's the third line that I'm not having any luck with. Along with the error below, the VBA editor highlights the period between NoticeForm1 and CheckBox1; and that whole line is highlighted red.

"Compile Error. Expected: end of statement"

Please Login or Register  to view this content.

The answer to this will be quite simple, I'm sure... It has to do with how I'm trying to refer to CheckBox1_Click (where CheckBox1 is an item on me NoticeForm1).

[Richard Buttrey]

Interesting....I've never seen a procedure created within a procedure. Are you able to upload the workbook?

[mike_302]

I had a feeling that was going to be your response, but I mean -- in this case, SURELY the workbook adds nothing. This is entirely about how to define the action of with a CheckBox in a UserForm, outside the UserForm Code.

I really can't provide the workbook here. But I thought I'd framed the problem such that the workbook is irrelevant. The code block is the important bit.

[Richard Buttrey]

As long as the userform is live (and it can be hidden) then you don;t need to be IN the userform to address the objects.

If you have time to mock up a simple example based on your workbook I'm happy to take a look.

[Kyle123]

You can’t do that directly, why can’t you put the if clause within the click event handler of the checkbox? You can just pass a property to the UserForm then and switch in the click handler.

If that doesn’t work for you, then could you give us a bit more context? Your architecture doesn’t seem right for the VBA way of doing things, though it’s hard to make recommendations without some background