English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

does anyone know if it is possible to make a basic till software in microsoft excel

eg.
sheet 1 has a button 1 for £3.50,
sheet 2 has a button 2 for £2.75
sheet 3 has a button 3 for £3.99
sheet 4 has a totals page

if you click button 1, it will automatically add £3.50 to the totals page
If you then click button 2 twice it will add £2.75 x 2 to the totals sheet.

when done the total sheet will tell you how much the total is.

any help.

cheers

2007-02-06 02:13:15 · 4 answers · asked by Aiden D 1 in Computers & Internet Programming & Design

4 answers

This can all be done on one sheet.

Name the cell where you want the total as "Total", by selecting the cell then clicking menu Insert - Name - Define and typing "Total"

Click on View - Toolbars - Control Toolbox which will display the Control Toolbox.

In the Control Toolbox click on the Command Button icon, then click and drag on the spreadsheet to draw the first button. To change the text displayed on the button, click on the Properties icon in the Control Toolbox and type the new text in the field labeled Caption in the Properties dialog box.

Now click on the View Code icon in the Control Toolbox. That will bring up a Visual Basic procedure for the button. At the cursor type:

Range("Total").Value = Range("Total").Value + 3.50

Go back to the worksheet and create the second and third buttons and their code just like the first one, substituting the different prices in the formula above.

In the Control Toolbox, click the icon labeled "Exit Design Mode."

Close the Control Toolbox, save the worksheet, then give it a try!

2007-02-06 13:31:36 · answer #1 · answered by Joliet Jake 3 · 0 0

It is certainly possible. All you have to do is put the constants into a sheet, any sheet in the workbook. Insert a control, such as a command button. Then, double-click the command button. You will get a dialog that wants you to write code. Go back to the spreadsheet into which you created the control and type a formula, such as =3.50 * A1. After that, anytime that you put a value in A1 and click the command button, voila!

2007-02-06 02:23:26 · answer #2 · answered by Kokopelli 6 · 0 0

As others have reported, if restarting the appliance and restarting the computer do not help, you ought to attempt reverting Vista to a save element from before the topic matters began, or, if that fails, reinstalling the appliance. The latter 2 steps are predicated on the perception of a few style of DLL mixup. i should be shocked if reinstalling place of work 2002 does not sparkling up this example; yet as a very last hotel you ought to confirm in case you may run it less than the recent version of residing house windows's emulation of its predecessors. contained in the mean time there is continuously Notepad, or in the event you call for effective factors, Notepad++. also, if my recollection serves, is place of work 2002 quite pronounced as place of work XP?

2016-12-03 19:21:48 · answer #3 · answered by ? 4 · 0 0

This one is fun. Here is an example.
Sample contains macros Set tools/macros/security to medium to run it.

2007-02-06 14:53:18 · answer #4 · answered by unnga 6 · 0 0

fedest.com, questions and answers