Inserting floating boxes complete with formula/cell referencing

[Zolt]

I want to insert a floating box in excel that will
refernce what is in an actual cell somewhere else in the
worksheet. I have to be able to put this box independant
of the cell grid. ie: I will hava a dropdown box to
choose different units(m, ft, in, etc.) and I want the
selected unit to be dispaly in various places in the
worksheet in the middle of sentences. Therefore need some
kind of floating box like a text box, combo box, whatever,
just something to make it work.

If this is possible or if anyone could help me out, it
would be greatly appreciated.

 

[Tim Otero]

One way:

Use a shape from the drawing toolbar. Draw it on your sheet, select it, then
type your cell reference into the formula bar, i.e. "=B5". In order to
change it with a selection of a drop down you can use Data Validation or a
control from the control or forms toolbars. For moor info on Data
Validation, look here:

http://www.contextures.com/xlDataVal01.html

tim

 

[Tim Otero]

For moor info on Data

Validation, look here:

I know how to spell "more," really I do...Damn spell checker