How do I make a macro run when I double click cell A1 on Sheet1. The macro has reference to other sheets as well. I am new to VBA. Help me please.
How do I make a macro run when I double click cell A1 on Sheet1. The macro has reference to other sheets as well. I am new to VBA. Help me please.
Last edited by dittotharappel; 03-20-2009 at 01:16 PM.
Press Alt+F11 , it will open VBA Editor.
Select Worksheet from the first dropdown
Select BeforeDoubleClick in the second dropdown in the editor..
enter the code..
Shijesh Kumar
http://shijesh.wordpress.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks