VBA 'true' simulation of double-click

[i_excel]

I've seen the sendkeys ("F2") workaround, but I'm interested in whether or not a double-click event can really be simulated with vba.

Any help appreciated.
i_excel

 

[MARK858]

Explain what you think in the Sendkeys option is different to the normal double click.

 

[i_excel]

Eg. If i double-click on a chart series it opens the properties dialogue for that element (on mac), whereas F2 places the cursor in the formula bar (in which the series formula is displayed).

 

[MARK858]

Not home to test but what happens if you do a

Application.SendKeys "{ENTER}"

after the Application.SendKeys "{F2}"?

 

[i_excel]

Sorry, I meant by my example to demonstrate that sendkeys F2 is not equivalent to a double click. I'm on mac, so I don't think sendkeys is an option.

 

[MARK858]

On a Mac I think you will struggle as you can't use SendKeys (that isn't a bad thing) or API's. I think your only sensible option would be AppleScript down the lines of the thread below (which I haven't read through fully or see if there is a close option).

VBA: SendKeys for the Mac

Can someone please confirm for me whether or not the 'SendKeys' statement is available for the Mac (Excel v.X). When I try something as simple as... SendKeys "ABC" ...I receive the following error... "Run-time error '5': Invalid procedure call or argument" Thanks!

www.mrexcel.com

 

[i_excel]

Thanks, yeah.. it's not seeming simple that's for sure. Frustrating that the functionality available in excel2011 isn't available in subsequent editions of excel - it was very straightforward in 2011.

 

[MARK858]

Frustrating that the functionality available in excel2011 isn't available in subsequent editions of excel - it was very straightforward in 2011

Couldn't say I am afraid, the last time I had a Mac I was on 2008 (which didn't have VBA at all ) VBA has supposed to have improved a bit in the latest versions for Mac but I am only going by what others have stated.

Not having SendKeys isn't a bad thing though.