i have the following code which gets the text from an autoshape oval an
puts it into a textbox

Worksheets("3.data").TextBox1.Text = _
Worksheets("2.pla
only").Shapes(Application.Caller).TextFrame.Charac ters.Text

my problem is some of these ovals have more than one bit of text.
basically they are reference numbers, they are mostly just one numbe
per oval, but some have for example 6675-6679, <carriage retur
hereSH-639 or even just 6675,<return hereTA06

and im trying to perform searches based on the text it gets out of th
ovals so i need a way of selecting the text from the start to eithe
the ',' character, the '-' character or a return/new line character
and putting that into the textbox rather than the current way o
sticking the entire lot of text into it.

ideally in situations where theres more than one reference in the ova
i would provide a quick way of choosing which one they want to us
after they click that oval but i think this may be too complicated.

any ideas

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