CheckBox1

[mikeymay]

When adding a check box do you have to intially declare it prior to 1st run of code after adding a check box?

I have just added a check box to a user form and VBA didn't recognise it. I declared it as a variable and suddenly VBA recognised all the lables, check boxex and associated text boxs.

Why does this happen?

[zaza]

Does it then cease to recognise it if you remove the declaration, or was it just having trouble in the first place? I myself have had experience of dodgy controls on Userforms in VBA (not associating code, for example) that required an Office restart to cure...


zaza

[mikeymay]

I can remove the declaration but it is still recognised.

I can only assume that as it is on the user form it is stored when intially used.

Can be a bit confusing when entering the check box name in the script and it isn't recognised. But now I know....................