ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selecting only some characters, using "characters property" (https://www.excelbanter.com/excel-programming/404932-selecting-only-some-characters-using-characters-property.html)

phil

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?


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com