ExcelBanter - Limit characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Limit characters (https://www.excelbanter.com/excel-programming/379392-limit-characters.html)

Patrick Simonds

Limit characters

Is there any way to alter the code below so that the Selection Value is
restricted to the first 14 characters?

Selection.Value = ListBox1.List(ListBox1.ListIndex, 0)

JMB

Limit characters

Perhaps
Selection.Value = Left(ListBox1.List(ListBox1.ListIndex, 0) ,14)

"Patrick Simonds" wrote:

Is there any way to alter the code below so that the Selection Value is
restricted to the first 14 characters?

Selection.Value = ListBox1.List(ListBox1.ListIndex, 0)

All times are GMT +1. The time now is 03:20 AM.