Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Attaching a particular user defined function to cust button
Hello All
Quick question can I attach a user defined function from Personal workbook to a customized button, I know I can right mouse click the button and assign macro but the list does not include functions. Probably doing something v wrong help would be much appreciated TIA Ajay |
#2
|
|||
|
|||
Ajay,
Why are you using a function? Functions return a result to the caller, so even if you could assign it, no-one would see the answer. A button is better served to run a routine (macro, sub) that does things, like colour cells, etc. -- HTH RP (remove nothere from the email address if mailing direct) "Ajay" wrote in message ... Hello All Quick question can I attach a user defined function from Personal workbook to a customized button, I know I can right mouse click the button and assign macro but the list does not include functions. Probably doing something v wrong help would be much appreciated TIA Ajay |
#3
|
|||
|
|||
Ajay,
We may have a terminology problem here. If it's really a user-defined function, it can be called only in a formula, not from a button. If the macro is a sub (not a function), then it can be assigned to a button. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Ajay" wrote in message ... Hello All Quick question can I attach a user defined function from Personal workbook to a customized button, I know I can right mouse click the button and assign macro but the list does not include functions. Probably doing something v wrong help would be much appreciated TIA Ajay |
#4
|
|||
|
|||
No problem it was just a thought I have a lot of user defined functions listed
and I just wondered if I could get to one or more slightly quicker than usual!! I use one of Dave Petersons the multiple lookup function a lot which works great just thought I could put it on a toolbar/button. Thanks for the replies Ajay "Earl Kiosterud" wrote: Ajay, We may have a terminology problem here. If it's really a user-defined function, it can be called only in a formula, not from a button. If the macro is a sub (not a function), then it can be assigned to a button. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Ajay" wrote in message ... Hello All Quick question can I attach a user defined function from Personal workbook to a customized button, I know I can right mouse click the button and assign macro but the list does not include functions. Probably doing something v wrong help would be much appreciated TIA Ajay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user defined date | Excel Worksheet Functions | |||
user defined formats for small numbers | Excel Discussion (Misc queries) | |||
User defined charts- font size too small | Charts and Charting in Excel | |||
Function that gives Windows current user name? | Excel Worksheet Functions | |||
how to move user defined function | Excel Worksheet Functions |