Hi Santosh, You have declared number variables as Integer, which have a maximum allowance of (approx) +/- 32000. Dim A As Integer Dim B As Integer Dim c As Integer Try declaring them as Long Dim A As Long Dim B As Long Dim c As Long
Regards - Dave. Date: Sat, 19 Mar 2011 20:22:18 +0530 Subject: $$Excel-Macros$$ combobox criteria not working From: santoshkumar.subu...@gmail.com To: excel-macros@googlegroups.com Hi Friends, Need a small help. Attached is a excel with a comand button which will populate a userform. In the userform there is a comand button called use combo which should calculate based on the combobox criteria. This is what not calculating properly. -- Regards Santosh santoshkumar.subu...@gmail.com -- ---------------------------------------------------------------------------------- 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 -- ---------------------------------------------------------------------------------- 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
