Thread: Limit characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
  
Posts: 2,062
Default 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)



Reply With QuoteReply With Quote