In this example

Document Sample
In this example Powered By Docstoc
					                                          Stock   Cost    Total               Code   Description   Price
      Speakers      FALSE    FALSE    0       0   £ 15.00 £     -             A      Speakers      £ 15.00
      DVD Drive     FALSE    FALSE    0       1   £ 60.00 £     -             B      DVD Drive     £ 60.00
      Zip Drive     FALSE    FALSE    0       2   £ 99.00 £     -             C      Zip Drive     £ 99.00
      Modem         FALSE    FALSE    0       3   £ 39.00 £     -             D      Modem         £ 39.00

                                                            £    -

In this example, checkboxes are used to allow the user to select options when purchasing a PC
The spreadsheet is constructed such that the user can only select items that are in stock, so if you try to
select Speakers, for example, the validation (actually a macro) will prevent you from ticking the box.

Columns B, C and D would be hidden in the actual system, and are just shown by way of explanation,
and also the stock table would probably be on another worksheet.
Stock
    0
    1
    2
    3

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:231
posted:9/15/2012
language:English
pages:2