Printable View
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?
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
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....................