Hi

I am looking for some code which would open a text box when a cell is clicked and populate that text box with information based on a value in the cell above.

The way i figure is I would need some sort of lookup in the macro.

The reason why I am doing this is because I have a large slabs of text and dont want to make the cell any bigger to display it.

Any help would be greatly appreciated.