Adding a commandbutton in Excel 2003
 

How do I add a commandbutton in Excel 2003 and modify its
characteristics? I have pasted a commandbutton from the control group
and modified its caption. I am not able to change its font name, size
or make it bold.
Also, how do I attach macro code to it to cause it to execute. I am
trying to translate a task given to Excel 2007 users.
Thank you.

Adding a commandbutton in Excel 2003
 

Go in design mode and then right-click the commandbutton to go to the
Properties.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"HappySenior" wrote:

How do I add a commandbutton in Excel 2003 and modify its
characteristics? I have pasted a commandbutton from the control group
and modified its caption. I am not able to change its font name, size
or make it bold.
Also, how do I attach macro code to it to cause it to execute. I am
trying to translate a task given to Excel 2007 users.
Thank you.

Adding a commandbutton in Excel 2003
 

On Jul 19, 12:16*pm, Wigi wrote:
Go in design mode and then right-click the commandbutton to go to the
Properties.

--
Wigihttp://www.wimgielis.be= Excel/VBA, soccer and music



"HappySenior" wrote:
How do I add a commandbutton in Excel 2003 and modify its
characteristics? I have pasted a commandbutton from the control group
and modified its caption. I am not able to change its font name, size
or make it bold.
Also, how do I attach macro code to it to cause it to execute. I am
trying to translate a task given to Excel 2007 users.
Thank you.- Hide quoted text -

- Show quoted text -

I am unable to locate design mode in Excel 2003...

Adding a commandbutton in Excel 2003
 

It's the rules pictogram on the Visual Basic Toolbar.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"HappySenior" wrote:

On Jul 19, 12:16 pm, Wigi wrote:
Go in design mode and then right-click the commandbutton to go to the
Properties.

--
Wigihttp://www.wimgielis.be= Excel/VBA, soccer and music



"HappySenior" wrote:
How do I add a commandbutton in Excel 2003 and modify its
characteristics? I have pasted a commandbutton from the control group
and modified its caption. I am not able to change its font name, size
or make it bold.
Also, how do I attach macro code to it to cause it to execute. I am
trying to translate a task given to Excel 2007 users.
Thank you.- Hide quoted text -

- Show quoted text -

I am unable to locate design mode in Excel 2003...

Adding a commandbutton in Excel 2003
 

Sounds like you created a button using the Forms Toolbar


Gord Dibben MS Excel MVP

On Sat, 19 Jul 2008 11:41:42 -0700 (PDT), HappySenior
wrote:

On Jul 19, 12:16*pm, Wigi wrote:
Go in design mode and then right-click the commandbutton to go to the
Properties.

--
Wigihttp://www.wimgielis.be= Excel/VBA, soccer and music



"HappySenior" wrote:
How do I add a commandbutton in Excel 2003 and modify its
characteristics? I have pasted a commandbutton from the control group
and modified its caption. I am not able to change its font name, size
or make it bold.
Also, how do I attach macro code to it to cause it to execute. I am
trying to translate a task given to Excel 2007 users.
Thank you.- Hide quoted text -

- Show quoted text -

I am unable to locate design mode in Excel 2003...

Adding a commandbutton in Excel 2003
 

On Jul 19, 3:33*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Sounds like you created a button using the Forms Toolbar

Gord Dibben *MS Excel MVP

On Sat, 19 Jul 2008 11:41:42 -0700 (PDT), HappySenior



wrote:
On Jul 19, 12:16*pm, Wigi wrote:
Go in design mode and then right-click the commandbutton to go to the
Properties.

--
Wigihttp://www.wimgielis.be=Excel/VBA, soccer and music

"HappySenior" wrote:
How do I add a commandbutton in Excel 2003 and modify its
characteristics? I have pasted a commandbutton from the control group
and modified its caption. I am not able to change its font name, size
or make it bold.
Also, how do I attach macro code to it to cause it to execute. I am
trying to translate a task given to Excel 2007 users.
Thank you.- Hide quoted text -

- Show quoted text -

I am unable to locate design mode in Excel 2003...- Hide quoted text -

- Show quoted text -

Yes, my problem was using the wrong toolbar to add the commandbutton.
I never noticed the Visual Basic toolbar. Using that one, I was able
to change the font on the commandbutton and attach a macro. The
commandbutton works the work it is suppose to. Many thanks to all for
the total contribution! Don