IF

adamswalwell

New Member
Joined
Nov 4, 2005
Messages
29
So I have used the formula that I was given so that if I was to click on a macro button it would add to a reciept and deduct the value from the stock sheet but now for my Fish and Chip Shop I would like to be able to have a warning pop-up when the stock reaches a certain level (50 for example)

So, to get onto the system you have to enter a password to get to the main menu and from there you select either sales or stock I would like it that after the correct password was entered there would be a warning window popping up saying that for example fish needs re-ordering. This would happen for all of the stock when it reached a certain level so that I know when i need to re-order.

If anyone is able to help me I would grately appreciate it!!
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
So, what do you need help with? For the syntax of a 'If' check out XL VBA help for 'if statement' (w/o the quotes). For how to do a pop up check out XL VBA help for 'msgbox'.
 

adamswalwell

New Member
Joined
Nov 4, 2005
Messages
29
I would like it so that because I have set it so that a password comes on when you click from the user interface onto the main menu after the correct password is entered i would like it to be able check all the stock levels of the different products within the workbook and then generate a pop up window with "warning stock level of (product name) low" for as many products as there are which are below a set stock level so that i no when to re-order.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,062
Messages
5,569,980
Members
412,301
Latest member
excelmaps
Top