View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.programming
[email protected] got.sp4m@googlemail.com is offline
external usenet poster
 
Posts: 10
Default a button on an excel cell

Thanks for the tip, but this was just a (self-inflicted) exercise to
see if I had gotten this stuff correctly :-P Might come in handy if I
was to handle different objects/events for many controls etc.

best regards
Peder

On Jan 9, 10:48*am, "Peter T" <peter_t@discussions wrote:
Another thought - if you are only after a button-click event and you are
using VBA - might be simpler to add a button form the Forms toolbar and
assign its onAction property to a macro in your wb. In the macro, to
identify which button -
sButtonName = Application.Caller

Pros & Cons with both approaches.

Regards,
Peter T