Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting txt before a, or return character?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return position of 2nd, 3rd, ect occurrence of a character in a st | Excel Discussion (Misc queries) | |||
Printer return character | Excel Discussion (Misc queries) | |||
SELECTING FROM A DROP DOWN LIST BY TYPING FIRST CHARACTER | New Users to Excel | |||
Using replace to get rid of paragraph return character | Excel Discussion (Misc queries) | |||
Return the 6th thru the nth character? | Excel Worksheet Functions |