workbook is not having any macro it contains UDF user defined function. write =vrate(b1) in d1 and then drag down the formula. it work like excel formula
if you press alt + f11 and press on module 1 you can see the code Option Explicit Function vRate(iResult As Integer) As Variant Select Case iResult Case Is < 90: vRate = 0 Case Is >= 90, Is < 94: vRate = 10 Case Is >= 94, Is < 98: vRate = 25 Case Is >= 98, Is < 100: vRate = 50 Case Is >= 100, Is < 105: vRate = 75 Case Is >= 105: vRate = 100 End Select End Function its a user defined function not a macro to wite a macro you have to start with "Sub " then name of macro On Sun, Jul 3, 2011 at 4:11 PM, vijayajith VA <vijayajith...@gmail.com>wrote: > HI Sir, > > I am unable to run the program...if i press f5 or run the program. it will > ask > > "Create macro " please see the attached sheet. > > > thankyou > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> http://akoul.posterous.com/ *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel