Using MsgBox in Formula

  • Thread starter Thread starter guzzy
  • Start date Start date
G

guzzy

Hi All,

Just wondering if it is possible to use MsgBox in a Formula (withou
VBA) ie =IF(A1<=10, MsgBox"Order more stock") except when I do it thi
way I get the old Formula error... I thought it be good to use instea
of using conditional formating to change the cell red or without havin
to program it in VBA

Cheers in advance
guzz
 
Good evening guzzy

No can do I'm afraid - Msgbox is VBA only.

Your alternatives are conditional formatting, or having "blank" cel
contents turn into "Order more stock" when calculated levels becom
critical, using something like the IF statement that you suggested.

HTH

Dominic
 
What's wrong with =IF(A1<10,"Order more Stock",A1)


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get pi to appear in a message box when coded using VBA 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
linefeed in msgbox 2
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 2
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2
Simple Module for Excel 2007 in VBA 6
Whole Column Conditional Formatting 2
Excel Wildcard in Excel array formula 0

Back
Top