Excel User defined Functions

[wahmed]

Hello all,

I would like to make some user defined functions in Excel vba, I have managed to make that functions but problem is that they dont show help in entering data like excel own functions show.

Like when we enter =Vlookup( in excel then it start showing help menu which show Lookup_value,Table_array,Col_index etc which make easy for user to enter data as per function's requirement. but in User Defined function excel dot show any help like that which make very odd to remember each argument that which was for which purpose....

Could any one help me about that ?

Regards

Wahmed

 

[MrKowz]

Please read what I have suggested as you can add a description, it remains in view whilst working with the Function, so you can add enough text to cover your function needs.

If you use the formula-finder, then yes, this will work. However, I was referring to the intellisense box that pops up as you type a formula into a cell.

 

[CharlesChuckieCharles]

Dear Charles,

Lets change function name to DATECOUNT but you still will not get results required.

regards

wahmed

the parameters are better as ranges ( ie cells containing dates )

Public Function DATECount(start_date As Range, End_Date As Range) As Double
DATECount = (CVDate(End_Date) - CVDate(start_date))
 
End Function

Obviously you need some error checking in this function
what if either is not a date? etc

 

[CharlesChuckieCharles]

the parameters are better as ranges ( ie cells containing dates )

Public Function DATECount(start_date As Range, End_Date As Range) As Double
DATECount = (CVDate(End_Date) - CVDate(start_date))
 
End Function

Obviously you need some error checking in this function
what if either is not a date? etc

No leave as dates just me talking rubbish


as Trevor G says

run the following line in the immediate window.

Application.MacroOptions Macro:="DATECount", Description:="This calculates the number days between two dates!"

 

[Trevor G]

If you use the formula-finder, then yes, this will work. However, I was referring to the intellisense box that pops up as you type a formula into a cell.

I see your point.

I would advice that the Function Guide be used as you can at least place some text as the description.

It is occasionally hard to fulfil a task in the way the person would like to use it.

 

[wahmed]

thanks for all of your messages.

but it seems it is not possible what I would like to do

regards

wahmed