| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to click and highlight cells and calculate the total amount in MS Excel?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate the total amount by date | Excel Programming | |||
| calculate price * quantity = total amount in a row of excel forml. | Excel Worksheet Functions | |||
| format row of cells to highlight least amount | Excel Worksheet Functions | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Linear Mode
