I made a range that is called Batch1, which includes a break down of
information.
THere are two things that I want to do.
1) I want to be able to simply type in 'Batch1' into a cell and have it
automatically link to that range, same goes for a possible 'Batch2,
batch3,ect..'
2)I want that link to pop-up as a text box containing the infortation in the
range Batch1. I do not wnat it to be a hyperlink, but i would like it to,
when its selected, pop-up the window with a further breakdown of inforation.

If you have any suggestions or ideas, let me know. my work email is


Thank you.

Tyler,

It is really quite a difficult task you need to use the on change event and
check if the formula = 'batch1' or 'batch2'

You need to consider where it applies only on the one sheet or on other
sheets in the workbook.

Have a look at the on_change event for the worksheet.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"tyler.speer" wrote:

I made a range that is called Batch1, which includes a break down of
information.
THere are two things that I want to do.
1) I want to be able to simply type in 'Batch1' into a cell and have it
automatically link to that range, same goes for a possible 'Batch2,
batch3,ect..'
2)I want that link to pop-up as a text box containing the infortation in the
range Batch1. I do not wnat it to be a hyperlink, but i would like it to,
when its selected, pop-up the window with a further breakdown of inforation.

If you have any suggestions or ideas, let me know. my work email is


Thank you.