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

creating functions

ResolvedVersion 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:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.