problems adding botton to a menu bar
 

Hello, I created an add in with a userform, I want to create a button that
opens the userform when clicked, in order to doing so I have until now in my
add in workbook:

Private Sub Workbook_AddinInstall()
Application.CommandBars("Formatting").Controls.Add
Type:=msoControlButton,
ID:=2950, Befo=13
End Sub

but I do not know how to assign the macro to the button; the macro writen in
the add in does not appear in the macro dialog box.

thanks

problems adding botton to a menu bar
 

Private Sub Workbook_AddinInstall()
With Application.CommandBars("Formatting").Controls.Add ( _
Type:=msoControlButton, ID:=2950, Befo=13)

.OnAction = "Test"
End With
End Sub


--
__________________________________
HTH

Bob

"filo666" wrote in message
...
Hello, I created an add in with a userform, I want to create a button that
opens the userform when clicked, in order to doing so I have until now in
my
add in workbook:

Private Sub Workbook_AddinInstall()
Application.CommandBars("Formatting").Controls.Add
Type:=msoControlButton,
ID:=2950, Befo=13
End Sub

but I do not know how to assign the macro to the button; the macro writen
in
the add in does not appear in the macro dialog box.

thanks

problems adding botton to a menu bar
 

Thnaks, It worked perfectly;

other question,
How to add a different image to the macro button??
How to change the button description?

"Bob Phillips" wrote:

Private Sub Workbook_AddinInstall()
With Application.CommandBars("Formatting").Controls.Add ( _
Type:=msoControlButton, ID:=2950, Befo=13)

.OnAction = "Test"
End With
End Sub


--
__________________________________
HTH

Bob

"filo666" wrote in message
...
Hello, I created an add in with a userform, I want to create a button that
opens the userform when clicked, in order to doing so I have until now in
my
add in workbook:

Private Sub Workbook_AddinInstall()
Application.CommandBars("Formatting").Controls.Add
Type:=msoControlButton,
ID:=2950, Befo=13
End Sub

but I do not know how to assign the macro to the button; the macro writen
in
the add in does not appear in the macro dialog box.

thanks

problems adding botton to a menu bar
 

If you want one of Excel's images, you just need to set the FaceId property.
If you want a custom image, you need to save it in your workbook, copy and
paste it in.

--
__________________________________
HTH

Bob

"filo666" wrote in message
...
Thnaks, It worked perfectly;

other question,
How to add a different image to the macro button??
How to change the button description?

"Bob Phillips" wrote:

Private Sub Workbook_AddinInstall()
With Application.CommandBars("Formatting").Controls.Add ( _
Type:=msoControlButton, ID:=2950, Befo=13)

.OnAction = "Test"
End With
End Sub


--
__________________________________
HTH

Bob

"filo666" wrote in message
...
Hello, I created an add in with a userform, I want to create a button
that
opens the userform when clicked, in order to doing so I have until now
in
my
add in workbook:

Private Sub Workbook_AddinInstall()
Application.CommandBars("Formatting").Controls.Add
Type:=msoControlButton,
ID:=2950, Befo=13
End Sub

but I do not know how to assign the macro to the button; the macro
writen
in
the add in does not appear in the macro dialog box.

thanks

problems adding botton to a menu bar
 

Great, thanks for your help, everything worked perfectly now!!!



"Bob Phillips" wrote:

If you want one of Excel's images, you just need to set the FaceId property.
If you want a custom image, you need to save it in your workbook, copy and
paste it in.

--
__________________________________
HTH

Bob

"filo666" wrote in message
...
Thnaks, It worked perfectly;

other question,
How to add a different image to the macro button??
How to change the button description?

"Bob Phillips" wrote:

Private Sub Workbook_AddinInstall()
With Application.CommandBars("Formatting").Controls.Add ( _
Type:=msoControlButton, ID:=2950, Befo=13)

.OnAction = "Test"
End With
End Sub


--
__________________________________
HTH

Bob

"filo666" wrote in message
...
Hello, I created an add in with a userform, I want to create a button
that
opens the userform when clicked, in order to doing so I have until now
in
my
add in workbook:

Private Sub Workbook_AddinInstall()
Application.CommandBars("Formatting").Controls.Add
Type:=msoControlButton,
ID:=2950, Befo=13
End Sub

but I do not know how to assign the macro to the button; the macro
writen
in
the add in does not appear in the macro dialog box.

thanks

problems adding botton to a menu bar
 

..Caption = "Description"
..FaceID = the ID number of an image

Mike F

"filo666" wrote in message
...
Thnaks, It worked perfectly;

other question,
How to add a different image to the macro button??
How to change the button description?

"Bob Phillips" wrote:

Private Sub Workbook_AddinInstall()
With Application.CommandBars("Formatting").Controls.Add ( _
Type:=msoControlButton, ID:=2950, Befo=13)

.OnAction = "Test"
End With
End Sub


--
__________________________________
HTH

Bob

"filo666" wrote in message
...
Hello, I created an add in with a userform, I want to create a button
that
opens the userform when clicked, in order to doing so I have until now
in
my
add in workbook:

Private Sub Workbook_AddinInstall()
Application.CommandBars("Formatting").Controls.Add
Type:=msoControlButton,
ID:=2950, Befo=13
End Sub

but I do not know how to assign the macro to the button; the macro
writen
in
the add in does not appear in the macro dialog box.

thanks