hey guys, just wanted to know if we can generate a button on an excel cell!
also, if we can, how to do we handle its actions like onButtonClick( ) etc?!

Hi,

You can try this to get you going maybe.

View|Toolbars - Forms

On the toolbar click the button Icon and and the worksheet point-left click
and drag to get a button the size you want.

In the popup click 'NEW' and enter the following code

msgbox "Hello World"

Close VB editor and return to your sheet and click the button. All you need
to do now is add some meaningful code to that button.

Mike


"NA_AB" wrote:

> hey guys, just wanted to know if we can generate a button on an excel cell!
> also, if we can, how to do we handle its actions like onButtonClick( ) etc?!

From your adjacent post I guess you mean you want a button on a sheet to
call code in your comaddin. You'd do that pretty much the same way as with
an Office.CommandBarButton. Ensure your addin has a reference to MSForms
object library and use WithEvents btn as MSForms.CommandButton.

Set c.btn = xlApp.ActiveWorkbook.Activesheet.OLEObjects(<name or
index>).Object

See VBA help how to add an ActiveX button to a worksheet.

Unlike the CommandBarButton which only exposes a click event, the
CommandButton exposes a range of events as well as click.

Regards,
Peter T

"NA_AB" <(E-Mail Removed)> wrote in message
news:149C3A70-DD19-46CC-8D53-(E-Mail Removed)...
> hey guys, just wanted to know if we can generate a button on an excel
> cell!
> also, if we can, how to do we handle its actions like onButtonClick( )
> etc?!

> Ensure your addin has a reference to MSForms object library

Should have said "Microsoft Forms 2.0" (FM20.dll)

Also, perhaps I should have clarified I was talking about a button from the
'Control toolbox' toolbar (not the Forms toolbar)

Peter T

"Peter T" <peter_t@discussions> wrote in message
news:OiGYMr$(E-Mail Removed)...
> From your adjacent post I guess you mean you want a button on a sheet to
> call code in your comaddin. You'd do that pretty much the same way as with
> an Office.CommandBarButton. Ensure your addin has a reference to MSForms
> object library and use WithEvents btn as MSForms.CommandButton.
>
> Set c.btn = xlApp.ActiveWorkbook.Activesheet.OLEObjects(<name or
> index>).Object
>
> See VBA help how to add an ActiveX button to a worksheet.
>
> Unlike the CommandBarButton which only exposes a click event, the
> CommandButton exposes a range of events as well as click.
>
> Regards,
> Peter T
>
> "NA_AB" <(E-Mail Removed)> wrote in message
> news:149C3A70-DD19-46CC-8D53-(E-Mail Removed)...
>> hey guys, just wanted to know if we can generate a button on an excel
>> cell!
>> also, if we can, how to do we handle its actions like onButtonClick( )
>> etc?!
>
>

hey Mike, JBeaucaire, aamerrasheed, thank you guys but my exact dealing is
with the excel addin as peter has rightly stated! thanks Peter

n btw, peter, could you look into this once please..
http://www.microsoft.com/communities...sloc=en-us&p=1

how to generate the command button on the active cell?!?!

I don't know the C# syntax but in VB/A -

Dim ole as Excel.OLEObject
With xlApp.ActiveCell
Set ole = xlApp.ActiveSheet.OLEObjects.Add("Forms.CommandButton.1", _
Left:=.Left, Top:=.Top, Width:=115#, Height:=24#)
End With
ole.Visible = True

' trap the button's events in a WithEvents class
Set c = New clsBtnEvents
Set c.btn = ole.Object

Regards,
Peter T


"NA_AB" <(E-Mail Removed)> wrote in message
news:918575BF-0023-4B5D-8628-(E-Mail Removed)...
>
> how to generate the command button on the active cell?!?!

thanks a ton peter... thanks for your help!

"Peter T" wrote:

> I don't know the C# syntax but in VB/A -
>
> Dim ole as Excel.OLEObject
> With xlApp.ActiveCell
> Set ole = xlApp.ActiveSheet.OLEObjects.Add("Forms.CommandButton.1", _
> Left:=.Left, Top:=.Top, Width:=115#, Height:=24#)
> End With
> ole.Visible = True
>
> ' trap the button's events in a WithEvents class
> Set c = New clsBtnEvents
> Set c.btn = ole.Object
>
> Regards,
> Peter T
>
>
> "NA_AB" <(E-Mail Removed)> wrote in message
> news:918575BF-0023-4B5D-8628-(E-Mail Removed)...
> >
> > how to generate the command button on the active cell?!?!
>
>
>

I'm really in need of some help, could you guide me through the way I can get
its C# equivalent code?

I don't know C# so I'm afraid you'll have to translate the VB/A example I
gave you.

Regards,
Peter T

"NA_AB" <(E-Mail Removed)> wrote in message
news:9B4A614C-780C-483C-BC44-(E-Mail Removed)...
> I'm really in need of some help, could you guide me through the way I can
> get
> its C# equivalent code?