what i have is a whole bunch of autoshape 'ovals' on one sheet (loo
like text bubbles really) and i need a way of reading the value from a
oval. The reason is I am trying to set it up so that i can have
function or macro or something so that when a user clicks on th
bubble, it takes the text from that bubble, puts it into a box o
sheet2 and presses the 'search' button that I have set up.

I tried recording a macro for clicking the bubble, copying the text i
it and pasting it, but the macro code copied the text literally
meaning if the text in the box changed, the macro replaces the new tex
with the macroed text and pastes that into the sheet2 box. It als
refused to paste the text into a textbox on sheet2, it would only past
it into a cell, which i can deal with but it would be nice if it paste
it into a textbox. the important thing though is having it someho
copy the 'current' value of the oval bubble (especially as i need t
apply this macro to about 150 bubbles and i cant have 150 differen
macros).

anyone know how i can do this

--
Message posted from http://www.ExcelForum.com