View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
 
Posts: 258
Default 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)