constantly running macro?

[zilch4ry]

hi everyone,

is there anyway of running a macro constantly? I mean instead of assigning it to a macro button, which the user will have to manually press to run.

Any help will be appreciated,



Tom

 

[Jon von der Heyden]

Can you explain what it is that you want the macro to do?

 

[zilch4ry]

sure,

I am producing an excel spreadsheet for an ICT task which involves creating an ordering system for a restaurant. To begin the user will enter a quantity into the assigned cell next to each item they wish to purchase, then that information is shown in a final order screen. I have a macro (which I gained from help on here) which hides or shows certain rows in the final order, based on whether or not they have a quantity of 1 or higher in the assigned cell.


The question i have is, "is it possible to run the macro which hides or shows cells automatically, instead of having to manually click the assigned macro button every time an order changes?"

I hope that can help you, help me

 

[zilch4ry]

is there nothing simple i can add to the end of the code?

 

[GlennUK]

... The question i have is, "is it possible to run the macro which hides or shows cells automatically, instead of having to manually click the assigned macro button every time an order changes?"
...

I can't imagine how that would work. Can you describe how you think this would work exactly?

Surely all options would have to be available at the start of an order, and then rows be hidden when the order is placed .... not as you go ... how would you know when to hide cells, what would be the trigger?

 

[MrKowz]

We could have a separate procedure monitor the cells where you enter quantity for changes, and then have that call the macro automatically. Can you describe what range you enter quantities on, as well as the name of the other macro?

 

[Trevor G]

Have you considered having a stock sheet and then look to use Validations with VLookup and IF statement,

Validation gives drop down of code (food item), Vlookup gives you the item and cost etc, If statement to keep data invisible until you select from validation.

See sample below, small stock sample then if and vlookup

Excel Workbook
	B	C	D	E
1	Fruit and Veg Stall
2	Code	Stock	Price	Level Remaining
3	A1	Apples	0.45	63
4	A2	Bananas	0.62	78
5	A3	Pears	0.87	456
6	A4	Oranges	0.95	65
7	A5	Grapes	0.56	635
8	A6	Potatoes	3.21	214
9	A7	Tomato's	0.41	289
10	A8	Onions	0.63	381
11	A9	Mushrooms	0.23	8963
12	A10	Lettus	0.74	85
13
14	Code	Stock	Price	Level Remaining
15	A6	Potatoes	3.21	214
16
17
18
19
20
21
22
Lookup Functions