Friday, January 22, 2010

Microsoft Excel - Inserting a Button (Form Control)?

I want to add buttons representing certain products at certain prices. In ICT class I am doing a cinema and want different buttons to represent different products at different prices. So when i click the button in a cell a formula adds up how much it is costing.





Does anyone know how to do it because there is Macros i believe involved and I hate them!





Thanks in advance!Microsoft Excel - Inserting a Button (Form Control)?
use Help:


Add an ActiveX control : its says


- Display the Control Toolbox:


- point to Toolbars on the View menu,


- and then click Control Toolbox. ';





and then... yes, you have to


Add then View Code to add the macro code.





depending on what you want to do, there is the record Macro facility, and you can cut and paste from that.





for the calculation:


So I guess, you


- have all the all the possible combinations of prices - in a list


for the variable (user entry square)





will have answer box.


and just have a macro that copies the answer you need to that box,


or neater sets a index to that earlier list.


which causes the spreadsheet to recalcuate that box.

No comments:

Post a Comment