assigning macro

[Bobthebuilder]

How do you assign a change macro to a checkbox (created from the forms toolbar)?

How do you find the name of checkbox after it has been created.
I've also tried to reference the cell that the checkbox is linked to and it doesn't seam to work.

I've tried to use the following code ...

private sub no11_click()

code in here

end sub

Please and thanks!!

 

[Bobthebuilder]

getting objects names

Further to above...

How do you get the objects name!

In this case, a checkbox created from the forms toolbar???

Any ideas

 

[Egress1]

Re: getting objects names

Further to above...

How do you get the objects name!

In this case, a checkbox created from the forms toolbar???

Any ideas

ALT-F11

Select the form in the editor right click the object and select PROPERTIES the name of the object is at the top of the properties box

 

[Andrew Poulsom]

If the CheckBox is from the Forms Toolbar, right click it and the name will appear in the Name box (to the left of the Formula Bar). You can change it by editing the text and pressing Enter.

To assign a macro, right click the CheckBox and choose Assign Macro.

Why aren't you using a CheckBox from the Control Toolbox. It might be easier.