Sum Values and comparison with coloum and give MSG using Macros

**Manojkanwar** · 01-14-2013, 10:24 PM

Hi,

I need help to know how to write VBA coding to do SUM of rows and than comparison with one fixed coloum and give the error message if value exceeds,

Fixed col. Jan Feb March April Comparison Pop Msg
100 10 20 30 20 80
200 20 30 40 50 140
300 30 50 60 200 340 Value exceeds

Thanks a lot

**benishiryo** · 01-14-2013, 10:51 PM

hi Manojkanwar, welcome to the forum. it's always good to provide a sample Excel file. do you need a pop up message that shows 1 at a time which exceeds? or show all that exceeds? or have a text "Value exceeds" in the row?

for the 1st:

Please Login or Register  to view this content.

for the 3rd:

Please Login or Register  to view this content.

Sum Values and comparison with coloum and give MSG using Macros

LinkBack

Thread Tools

Rate This Thread

Display

Sum Values and comparison with coloum and give MSG using Macros

Re: Sum Values and comparison with coloum and give MSG using Macros

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions