Printable View
Recently, a strange problem has been afflicting me. When I create Userforms in Office and add controls thereto, double-clicking does not take me to the events sub for that object. Rather it takes me to the General Declarations section, and the object is not listed in the drop-down. Hence there is no way to add code t othat object, because the code window doesn't acknowledge that the object exists. A save and a restart can cure it, though.
Most peculiar... :confused:
When you click on the left dropdown combo, do you see any of the controls you added?
Hey Rob,
In a "not-working" session, I can't see any of the controls I added in that session in the drop-down, but I can see all of the ones that were there when I loaded it up. It's as though the code window sticks itself at the point at which I loaded the file. I've tried typing the header in manually but it just keeps it in General Declarations; it doesn't associate it with the object.
Very strange.
I have experienced the same thing, the problem occurs occasionally in Word XP VBA editor.
Only way i have got round it is the same as you. Saving & closing & re-opening the file seems to fix the problem.... for a while anyway !!
Close your files and open the Office App only with no document or workbook. Then click Help > Detect and Repair and see if it helps. also a Office Update doesnt hurt either. If all else fails then try recreating the file and see if it starts to pick up controls again or just test out a new file and see if it works.