Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default Is it possible to pint and click from with VBA

Hello

Is it at all possible to point and click toolbar for within Excel VBA.
This is for a commercial Excel add-in application (don't have access the
VBA program). What I want to do is activate these functions from within
my own Userform.

Thaks
K

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Is it possible to pint and click from with VBA

Not point and click, but if it is a VBA add-in, you could try this

With Application.CommandBars("Standard").Controls("xxx" )
Application.Run .OnAction
End With

where xxx is the toolbar button caption

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kurb" wrote in message
. ..
Hello

Is it at all possible to point and click toolbar for within Excel VBA.
This is for a commercial Excel add-in application (don't have access the
VBA program). What I want to do is activate these functions from within
my own Userform.

Thaks
K



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default Is it possible to pint and click from with VBA

Thank you for your response.

Is there a way to get the Macro to create the coding for a series of
mouse actions (like can be done for Excel functions) ?

Thanks
K


Bob Phillips wrote:

Not point and click, but if it is a VBA add-in, you could try this

With Application.CommandBars("Standard").Controls("xxx" )
Application.Run .OnAction
End With

where xxx is the toolbar button caption




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a click on + symbol to open a root and click on -. changeyourbodychallenge.com Excel Discussion (Misc queries) 1 December 28th 09 03:22 PM
How to change syperlink from single click to double click syperlinker Excel Worksheet Functions 0 June 13th 08 05:01 PM
Disabling click and right-click on the Picture I inserted in an Excel document [email protected] Excel Worksheet Functions 1 June 2nd 06 09:13 PM
Click on graph bar to execute a double-click in a pivot table cell [email protected] Charts and Charting in Excel 4 August 3rd 05 01:37 AM
click buttons to do, re-click to un-do arciduca79[_6_] Excel Programming 2 March 4th 04 11:30 AM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"