| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with MessageBox coding for newbie
Hello All,
I need help with coding. I need a Warning Message Box "Re-Order Stock Now" (with OK button) to appear on all of my 30 product worksheets when the stock balance<= the reorder level for the product. All worksheet transactions are manual input. Re-Order levels are always stored in cell J9 of the worksheets. Stock balances all appear in column D (D9:D100). Thanks in advance for all help/advice. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with MessageBox coding for newbie
Why not just use Conditional Formatting (Format - Conditional Format) When
Cell value is less than 30 highlight the cell Red or something... -- HTH... Jim Thomlinson "Mac1" wrote: Hello All, I need help with coding. I need a Warning Message Box "Re-Order Stock Now" (with OK button) to appear on all of my 30 product worksheets when the stock balance<= the reorder level for the product. All worksheet transactions are manual input. Re-Order levels are always stored in cell J9 of the worksheets. Stock balances all appear in column D (D9:D100). Thanks in advance for all help/advice. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to see the chart coding? | Charts and Charting in Excel | |||
| Prevent error messagebox when refresing querytable from the web fails | New Users to Excel | |||
| Prevent error messagebox when refresing querytable from the web fails | Links and Linking in Excel | |||
| More than 6 conditional Formats....VBA Coding Advise please | New Users to Excel | |||
| Hidding Macro names and coding | Excel Discussion (Misc queries) | |||
Linear Mode
