message box refercing to data on another sheet.

[Stewit]

Hi I have another little tester for you brainiacs, I can't figure this out,
and I can't find specific reference to it anywhere, or find anything
remotely close to modify to get what I want.....

Sheet1 is a monthly sheet and is where the data entry takes place, im using
vlookup on sheet1 to get descriptions from sheet3 using a code on the
monthly data entry sheet, thats all working very very well.... thanks to
assistance from you good people.

Those same codes are reducing the stock levels on sheet 3 on entry. What im
really trying to achieve is a message box to popup no matter which month so
that's something like "currentworksheet" i'm in to tell me stock level item
1 is low and reorder at whatever level I set it to.

am7:am507 is where i need to get the low warning count from

Even a pointer to a site with similar things would be wonderful, i'm getting
into adjusting code to suit myself now

great bunch of teachers here

thanks in advance for yet more ideas and help.

Stewart

 

[BrianB]

Cannot really answer without knowing how your data is set up. This cod
snippet shows the general idea of how to compare 2 values and tak
action on the result :-

'----------------------------------------------------
If Workbooks("Book1").Worksheets("Sheet1").Value _
< Workbooks("Book").Worksheets("Sheet1").Value Then
'- message box
MsgBox ("Low stock")
'- highlight a cell
ActiveSheet.Range(ActiveCell.Row, 1).Interior.ColorIndex = 6
'- show entry on the current sheet
ActiveSheet.Range(ActiveCell.Row, 1).Value = "Low Stock"
End If
'--------------------------------------------------

Hope this helps

 

[Stewit]

Thanks for your input Brian,

I see a problem with my posting, I'm expecting people to know whats going on
in my head, I suffer from that all the time... I thought about what is an
easy generic way to post this problem and came up with.

Im wanting a msgbox to popup in the active sheet based on a value met in
another sheet of the same workbook. Generating a msgbox is ok but calling
it from Cell "am7" with a value of "3" is my problem in short.

I have 12 sheets of data entry which affect my separate stock sheet which is
500 rows long.

I can't implement the code that you posted, im not sure if it's my
inexperience in where to dump it or when i change the Book and sheet values
to match my actual book and sheets. I dropped the code in "this workbook"
and have been busy trying to get it to work lol without success but im one
of those persistant types

regards
Stewart