$$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

[Aju Chacko]

Dear experts,
Kindly help me with vba code for the following problem
,I have created a macro *that trap the event DOUBLE CLICKING* of mouse,But
i want to optimize in such a way that the *user need not double click each
time with the mouse*,Instead I want to create *double click of mouse using
VBA CODE*,so when this code *create double click event* ,the code written
for this event will get fired.

Thanking
you in advance

Aju V Chacko

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

[dguillett1]

I do not understand what you want. Send a file with a full explanation and 
examples.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Aju Chacko 
Sent: Wednesday, December 14, 2011 12:24 AM
To: excel macro forum 
Subject: $$Excel-Macros$$ How to create a double click using VBA CODE without 
actually double clicking on the mouse

Dear experts,
Kindly help me with vba code for the following problem ,I 
have created a macro that trap the event DOUBLE CLICKING of mouse,But i want to 
optimize in such a way that the user need not double click each time with the 
mouse,Instead I want to create double click of mouse using VBA CODE,so when 
this code create double click event ,the code written for this event will get 
fired.

Thanking you in 
advance

   Aju V Chacko

 
-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

[rajan verma]

hi
what do you want instead of Double Click.. when event will be fire?

Rajan

On 12/14/11, dguillett1  wrote:
> I do not understand what you want. Send a file with a full explanation and
> examples.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Aju Chacko
> Sent: Wednesday, December 14, 2011 12:24 AM
> To: excel macro forum
> Subject: $$Excel-Macros$$ How to create a double click using VBA CODE
> without actually double clicking on the mouse
>
> Dear experts,
> Kindly help me with vba code for the following problem
> ,I have created a macro that trap the event DOUBLE CLICKING of mouse,But i
> want to optimize in such a way that the user need not double click each time
> with the mouse,Instead I want to create double click of mouse using VBA
> CODE,so when this code create double click event ,the code written for this
> event will get fired.
>
> Thanking you
> in advance
>
>   Aju V Chacko
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


-- 
Regards
Rajan verma
+91 9158998701

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

RE: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

[Asa Rossoff]

Hi Aju,

This is a curious request. It sounds like perhaps you are "asking the wrong
question" :) -- The purpose of an event is to start execution of VBA code
when a certain triggering event occurs, such as a user action, calculation,
opening of a file, etc.  You are asking if you can emulate a user action
(from VBA code) in order to execute the VBA code you now have assoicated
with an event.  Although it is possible to emulate mouse clicks, it's not
possible using just VBA code.  You would I believe have to call out to the
Windows API to do it that way.

 

There is no need to do that.

You can execute other VBA code directly from the procedure that you propose
to trigger that event.

 

If your event is something like this:

SUB something_doubleclick()

' do something

END SUB

 

and your other code you envision is this:

SUB othercode()

' want to double click "something" here :[

END SUB

 

Do this to have the same effect ~

In a module create a procedure to do the thing you want to happen in your
doubleclick event:

SUB do_something()

' do something here

END SUB

 

then, in your doubleclick event call that routine:

SUB something_doubleclick()

do_something ' this calls the other procedure

END SUB

 

and also call the same routine from your other code:

SUB othercode()

do_something ' this calls the other procedure =]

END SUB

 

Hope this helps solve your query.

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aju Chacko
Sent: Tuesday, December 13, 2011 10:25 PM
To: excel macro forum
Subject: $$Excel-Macros$$ How to create a double click using VBA CODE
without actually double clicking on the mouse

 

Dear experts,

Kindly help me with vba code for the following problem
,I have created a macro that trap the event DOUBLE CLICKING of mouse,But i
want to optimize in such a way that the user need not double click each time
with the mouse,Instead I want to create double click of mouse using VBA
CODE,so when this code create double click event ,the code written for this
event will get fired.

 

Thanking you
in advance

 
Aju V Chacko

 

 

-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

[NOORAIN ANSARI]

Dear Aju,

Please find attached Worksheet Event Example sheet,

HTH,
-- 
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Wed, Dec 14, 2011 at 11:54 AM, Aju Chacko  wrote:

> Dear experts,
> Kindly help me with vba code for the following
> problem ,I have created a macro *that trap the event DOUBLE CLICKING* of
> mouse,But i want to optimize in such a way that the *user need not double
> click each time with the mouse*,Instead I want to create *double click of
> mouse using VBA CODE*,so when this code *create double click event* ,the
> code written for this event will get fired.
>
> Thanking
> you in advance
>
> Aju V Chacko
>
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


** 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Worksheet_Event.doc
Description: MS-Word document

Re: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

[Aju Chacko]

Dear  Noorin/Rajan verma/Asa rossof,
   *Thanks for ur
response*.I actually created a class module to trap double click event in
PIVOT Table,Now the code is written in such a way that when the user againg
double clck on drilled down sheet created by clicking on pivot
table,Another procedure *XX *executes.Now as suggested by asa I have
rewritten module in such a way that with the first double click itself the
procudre *XX also *executed by placing the call to the procedure in
suitable postion.
   Aju v
chacko
On Thu, Dec 15, 2011 at 11:35 AM, NOORAIN ANSARI
wrote:

> Dear Aju,
>
> Please find attached Worksheet Event Example sheet,
>
> HTH,
> --
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Wed, Dec 14, 2011 at 11:54 AM, Aju Chacko  wrote:
>
>> Dear experts,
>> Kindly help me with vba code for the following
>> problem ,I have created a macro *that trap the event DOUBLE CLICKING* of
>> mouse,But i want to optimize in such a way that the *user need not
>> double click each time with the mouse*,Instead I want to create *double
>> click of mouse using VBA CODE*,so when this code *create double click
>> event* ,the code written for this event will get fired.
>>
>> Thanking
>> you in advance
>>
>> Aju V Chacko
>>
>>
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
> ** 
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com