Inserting floating boxes complete with formula/cell referencing

  • Thread starter Thread starter Zolt
  • Start date Start date
Z

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.
 
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
 
Back
Top