VBA IN EXCEL

[Julian Campbell]

Not sure if this is the right place for this post.

I have a spread sheet for my stock use on site at work. It is approx 500
lines in length. I already have a conditionla format to highlight a cell
when it falls below a set figure (I use this colour change to remind myself
to re-order stk)

Is there a way I can use VBA to offer a text box in this case?

Thanks

Julian

 

[Guest]

Julian

What you could do is have a button on your excel spreadsheet ( or an icon on
the toolbar or an itm on a menu bar) which when you click will tell you which
items of stock you are running low of.

The box could tell you the name of the stock item, its current value, and
how far below the 'threshold' value it is.

This can be done (realtively straightforwardly) with VBA. Without knowing
more about your spreadsheet set-up I cannot say much more.

If you are interested to give me more details then I could give more
thorought directions...

I will check back to see if you reply...


Regards


Alex