Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting only some characters, using "characters property"
For years I have used a macro that has worked fine. I recently tried to use
one of its functions and it fails. The code used is, TaxNumber = .EditBoxes(6).Characters(1, 3).Text The contents of the edit box is "522L" but now, tax number returns the whole content of "522L" and not just the required "522". Is it my coding or has Excel 2003 been changed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If specific # of certain characters in a range, "OK", if not "Aler | Excel Worksheet Functions | |||
Extract text plus "n" characters or date on partial match | Excel Programming | |||
Excel custom autofilter- how to find wildcard characters but not as wildcards (e.g. "?") in a cell | Excel Discussion (Misc queries) | |||
shortcuts ("abbreviations", autocorrection) with non-wordbreaking characters | Excel Discussion (Misc queries) | |||
How do I remove "special characters" from cell data? | Excel Discussion (Misc queries) |