Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding XML element using Excel 2003 | Excel Programming | |||
Excel 2003 adding row info | Excel Discussion (Misc queries) | |||
Excel 2003 adding page breaks | Excel Discussion (Misc queries) | |||
Adding commandbutton to sheet | Excel Programming | |||
Adding commandbutton at run time | Excel Programming |