How to click and highlight cells and calculate the total amount in MS Excel?

B

Bon

Dear all

Could anyone give me sample code or example on implementing highlight
cells and calculating total pages and amount?

I have an excel file, which contain subjects name, book page number and
book cost. The format is as follow

A B C
1 Maths 200 $200
2 Eng 100 $100
3 Chinese 100 $100
4 History 250 $250

If I click B2, B4 and C3, those cells will be highlighted. The total
pages and total amount will be calculate at the bottom of the sheet.

I am a newbie on writing VBA and macro. Please give me some advices.

Thank you

Bon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help on generating non-duplicated result 0
Excel 2002: How to add without splitting blocks ? 3
Copying cells from one workbook to another 0
Pulling cell information from one workbook to another 3
Excel formula is calculating wrong total number on some of cells 4
How Do I 2
How to have an error popup once range cell amount is greater than 2
Excel VBA Programming...How to Trigger an Event WhenYou Move Off a Cell 2

Top