Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button in a toolbar to insert a specific function
Hi,
Is it possible to have a shortcut in my Menu to insert a specific function without going through the list or selecting it when I ckick on Insert - Function. I know how to customize my toolbar, but I want a button for the COS function for example. I have Excel 2003 SP3 Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button in a toolbar to insert a specific function
Hi Cathrine,
place this pocedure in your personal.xls Public Sub getCosine() On Error Resume Next ActiveCell.Value = "=COS(" & ActiveCell.Value & ")" End Sub Add your new control as usual and assign this macro to it. If you haven't used your personal.xls before have a look here. http://www.rondebruin.nl/personal.htm HTH "catherine" wrote: Hi, Is it possible to have a shortcut in my Menu to insert a specific function without going through the list or selecting it when I ckick on Insert - Function. I know how to customize my toolbar, but I want a button for the COS function for example. I have Excel 2003 SP3 Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button in a toolbar to insert a specific function
Thanks Jeff
I will try it Catherine "Jeff" a écrit dans le message de ... Hi Cathrine, place this pocedure in your personal.xls Public Sub getCosine() On Error Resume Next ActiveCell.Value = "=COS(" & ActiveCell.Value & ")" End Sub Add your new control as usual and assign this macro to it. If you haven't used your personal.xls before have a look here. http://www.rondebruin.nl/personal.htm HTH "catherine" wrote: Hi, Is it possible to have a shortcut in my Menu to insert a specific function without going through the list or selecting it when I ckick on Insert - Function. I know how to customize my toolbar, but I want a button for the COS function for example. I have Excel 2003 SP3 Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert comments on Option Button of Forms Toolbar | Excel Discussion (Misc queries) | |||
toolbar button to insert symbol | Excel Discussion (Misc queries) | |||
Assign macro to WB-specific toolbar button? | Excel Programming | |||
How would I move/insert a custom picture (button) onto the toolbar | Excel Discussion (Misc queries) | |||
Enable toolbar button in one specific worksheet | Excel Programming |