98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Creating functions
Creating functions
Resolved · Low Priority · Version 2010
Ceri has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access Introduction course
Creating functions
Hi,
When using a function that already exists in excel a small list comes up below as you type out the function of what you need to put in next. E.g =max(number1,number2...)
I have created a function in vba which requires 4 variables to be entered. The function (and variables needed) is this: DecayCorrect(isotope, initAct, initdate, desiredate)
it is working fine and if you press the fx button in order to get it up you then select each variable in turn and you can see the name of the variable you need. However if you click in a cell and type in the name of the function and an open bracket it does not provide the list as it does for pre-existing functions. Is it possible to get it to do this?
Thanks
RE: Creating functions
Hi Ceri
Thanks for getting in touch. I've looked into this before; you would expect this to be a straightforward process.
Unfortunately this is extremely difficult to program, and even then not very consistent. I'll leave you a couple of links and you can decide if you think it's worth attempting:
http://stackoverflow.com/questions/16903587/the-quest-for-the-excel-custom-function-tooltip
http://www.bettersolutions.com/excel/EIK284/YN723710331.htm
Sorry it's not better news.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 24 Jul 2014: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting Non Number Cells (Text)If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values. |