Creating checkboxes that change data

[cmo]

Hello everyone,

Can anyone help / make suggestions in achieving the following:

I am trying to create an invoice that summarises the total of the
products at the bottom of the spreadsheet.

What I want to achieve is some way of having various products in a row
which a user can select via some sort of check box (giving the product
a boolean value).
Each product would have a price value attached to it and when it is
selected the price should be added to the total.

This would therefore allow the user to select various products and the
total would be calculated accordingly.

This seems relatively simple in theory although I just don't know how
to do it so any help would be greatly received.

Thanks.

 

[Frank Kabel]

Hi

please do not crosspost. See one possible solution in your thread in
public.microsoft.excel

Frank