creating functions

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Creating functions

Creating functions

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

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.

View all Excel hints and tips


Server loaded in 0.06 secs.