Thanks to Bernie and jmoffat for help with creating a Commandbar. Now, I
still have a problem.

Where can I find a list of the parameters for creating the buttons?

Bernie's button was:

With myButton
.Caption = "Hello"
.Style = msoButtonIcon
.FaceId = 137
.Enabled = True
.OnAction = "SayHello"
End With

I want a button to have both text and an icon and to run a macro when
clicked. I've tried wading through the help files looking for Style,
FaceID, etc but no where have I found a list of what controls what. I
assume a button with text and an icon will be
..Style=.msoButton(something)and the text will be the .Caption. I've
tried IconText, TextIcon but nothing changes. Also by randomly plugging
in nembers for FaceID I've foumd a lot of different icons. Is there a
list somewhere of faceID icons?

Sorry to keep bothering everyone with these elementary questions

Bill

There are 10 types of people; those that understand binary and those
that don't.

Remove NOTME to reply direct

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Bill D. wrote:

> in nembers for FaceID I've foumd a lot of different icons. Is there a
> list somewhere of faceID icons?

Get the Face Identifier addin from John Walkenbach's page:

http://www.j-walk.com/ss/excel/files/developer.htm

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

Bill,

You want .Style = msoButtonIconAndCaption, obvious eh?<vbg>

You can see the possibles by looking up the Style property in Help under
commandbar controls.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bill D." <(E-Mail Removed)> wrote in message
news:us$(E-Mail Removed)...
> Thanks to Bernie and jmoffat for help with creating a Commandbar. Now, I
> still have a problem.
>
> Where can I find a list of the parameters for creating the buttons?
>
> Bernie's button was:
>
> With myButton
> .Caption = "Hello"
> .Style = msoButtonIcon
> .FaceId = 137
> .Enabled = True
> .OnAction = "SayHello"
> End With
>
> I want a button to have both text and an icon and to run a macro when
> clicked. I've tried wading through the help files looking for Style,
> FaceID, etc but no where have I found a list of what controls what. I
> assume a button with text and an icon will be
> Style=.msoButton(something)and the text will be the .Caption. I've
> tried IconText, TextIcon but nothing changes. Also by randomly plugging
> in nembers for FaceID I've foumd a lot of different icons. Is there a
> list somewhere of faceID icons?
>
> Sorry to keep bothering everyone with these elementary questions
>
> Bill
>
> There are 10 types of people; those that understand binary and those
> that don't.
>
> Remove NOTME to reply direct
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Beto, Thanks a big help.

Bob, Now it is.

Bill

There are 10 types of people; those that understand binary and those
that don't.

Remove NOTME to reply direct

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!