Watch Window

X

xirokx

Hi,

Please can someone explain the purpose of a watch window?

I have created a 26mb excel file which I use as an ordering system. I
order each month to cover two months worth of stock. In my excel sheet
I have used 2 colours black = I have 2 months stock red = a minus
figure showing I will run out before 2 months are over based of course
of current rate of sale.

Point being I would like to create a button on the sheet I can click to
show me all reds which are minus figures to show me which lines I will
run out of stock before the two months are over....

How can I acheive this task by a) recording a macro b ) using a watch
window (whatever that is)

Please help

Thanks in advance...........
 
N

Norman Jones

Hi Xirokx,

The Watch window provides a means of tracking VBA variables and expressions;
it has no direct relevance to Excel.

For your purposes, perhaps you could consider Excel's Autofilter or Advanced
Filter features?
 
Top