change TEXT to display in excel via vba

Question

Is there a way to change the text to display of all the hyperlinks in a sheet?

All I want to do it is run a macro to trim the the existing TEXT to Display to 5 chrs only? At the mo, my text to display is really big text string something like "21253.bla bla bla.wla wla wla. dah dah dah.jpg" and I only want to display 21253

Is this even possible? Regards Shei

Sorceri · Accepted Answer · 2013-09-19 21:21:26Z

1

Loop through the links on the sheets and use the left function to trim the text to display. Example below

Dim hl As Hyperlink
For Each hl In ActiveSheet.Hyperlinks
    hl.TextToDisplay = Left(hl.TextToDisplay, 5)
Next

answered Sep 19, 2013 at 21:21

Sorceri

8,0932 gold badges32 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

change TEXT to display in excel via vba

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related