return the first and last 10 characters in a string

[tony.reynolds]

I have a browse button and a small text box in a userform that users can select an excel file and the small text box displays the full path

is there a way i can show only the first and last 25 digits and just show "..." in the middle?

So the user can see the drive letter and then last portion of the string..

like

C:\Documents and Settin... ...uments\My Pictures\Test.jpg

 

[Scott Huish]

Why not just use GetOpenFileName instead of a UserForm?

But in answer to your question:

TextBox1=Left(Textbox1,25) & "......" & Right(Textbox1,25)

 

[tony.reynolds]

Thanks thats exactly what i wanted

I have a userform that uses getopenfilname

I use a form because it is backup wizard i have created so users can backup from an existing data and the user selects the file to backup from and a new name so it can save as 9keeps the original) ETC