Intellisense problem in VBA

abhiutd

Registered User.
Local time
Today, 06:46
Joined
Jul 28, 2008
Messages
48
Hello!
I'm a new VBA prgrammer so please bear with me. I added a button on one of the worksheets assigned a macro on its click event. Inside the method when i try to do "Me." the intellisense shows up for a second and then vanishes and Me turns to red. I dont know why its happening. Any help will be greatly appreciated.

Thank You.
 
sounds like you have a timer event running on a form and you need to either exit that form or go into design view so the timer doesn't run.
 
sounds like you have a timer event running on a form and you need to either exit that form or go into design view so the timer doesn't run.

Hi Bob,
I figurred the problem. I had anothr sheet in the same workbook that was running some automatic formulas. I changed their calculation to Manual and it resolved my problem. But i have another issue. The button and a dropdown that i added into my sheet, i'm not able to access in the code. If i am in the sheet code i should be able to see under Me right?

Thank You.
 

Users who are viewing this thread

Back
Top Bottom