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

Bon

Guest

Posts: n/a

5th Jan 2007

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

« Creating character combinations out of a possible set... | Need help 'cleaning up' a spreadsheet »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel cells in word to highlight on double click	CAPTGNVR	Microsoft Word New Users	0	1st Jun 2009 11:37 AM
Calculate the total amount by date	=?utf-8?B?6IKl5qyK?=	Microsoft Excel Programming	1	30th Nov 2005 04:38 PM
calculate price * quantity = total amount in a row of excel forml.	=?Utf-8?B?dC4gcmFtYWNoYW5kcmEgcmFv?=	Microsoft Excel Worksheet Functions	0	23rd Nov 2005 07:46 PM
How do I calculate a total amount on a form in Access.	=?Utf-8?B?YWRpY2tzb24=?=	Microsoft Access Forms	3	7th Jul 2005 08:20 PM
How do I calculate Amount of Sales Tax from Total Amount?	=?Utf-8?B?TWlrZVM=?=	Microsoft Excel Worksheet Functions	1	26th Mar 2005 07:49 PM