Thread: Insert leading spaces
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DejaVu[_59_] DejaVu[_59_] is offline
external usenet poster
  
Posts: 1
Default Insert leading spaces

I have a userform in which the user inputs *Miles Traveled* into two
text boxes -(max & min)-. The miles can be up to 5 characters (99999)
in length.

If the user, for example, enters "_1_" - "_500_"; I want that to be
converted to "_____1_" - "___500_".

I want all the leading characters to be spaces.
Hopefully this makes sense to someone!

TIA

DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=499477

Reply With QuoteReply With Quote