Rather that invoking a UDF from VBA code, is it possible to create a UDF, then go into an cell, proceed to enter a formula with an equal sign, and the name of your UDF will pop up just like a built-in function such as SUM or VLOOKUP?
For example, in Module 1, write the code for a UDF called DoubleSum.
Then in a spreadsheet with values, type in = and have the function called DoubleSum pop up as a choice?
Yes that is possible.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks