Function Create by VB and use.

By Md.shaiful islam Talukder | 9:23 PM |
Define function.

Some time need a function for easy work/reporting . But don't work memory how it is possible in ms excel .it
is easy by VB coding Here i include a example : define function create, i seem it is helpful. This Code are
Function Commission(Fee)
If Fee <= 1000 Then Commission = Fee * 0.1 Else Commission = Fee * 0.05
End Function

'To use this UDF push Alt+F11 and go Insert>Module and paste in the code. Push Alt+Q and save. The Function will appear under "User Defined" in the Paste Function dialog box (Shift+F3). Use the Function in any cell as shown below.
'=Commission(Cell Number)
'--------------------Md.Shaiful Islam Talukder---------                 


Post a Comment