I am trying to create a few new functions for Xl97 and store them as complements, then I load them up on my excel or others xls as "userdefinefunctions".
I can easy create Functions, define what I expect them to do by using this code:
example.
Public Function TC (E,P,e,p)
TC = E*p/P
End function
But My troubles start when I want to give an anknown user, who loads up the function, the meaning or a short expl. of E, e,p,P or TC,When you use a function on Xl97 (with the dialog box) you have not only an explanation file xxxx.HLP, but also, on the dialog box, you have a short description of every variant or argument (like E,e,p,P,TC) you are using.
My quetion is: How CAN I DO TO set a text description for those Users who my not know what to put or how to fill each argument or variant.
If somebody can understand my English Spelling pls. Help me, I am not a programmer or Macros Guru, I do what I can.
thanks
I can easy create Functions, define what I expect them to do by using this code:
example.
Public Function TC (E,P,e,p)
TC = E*p/P
End function
But My troubles start when I want to give an anknown user, who loads up the function, the meaning or a short expl. of E, e,p,P or TC,When you use a function on Xl97 (with the dialog box) you have not only an explanation file xxxx.HLP, but also, on the dialog box, you have a short description of every variant or argument (like E,e,p,P,TC) you are using.
My quetion is: How CAN I DO TO set a text description for those Users who my not know what to put or how to fill each argument or variant.
If somebody can understand my English Spelling pls. Help me, I am not a programmer or Macros Guru, I do what I can.
thanks