label overflow control, append "..."

this isn't a major issue but I am displaying target directories for saving a reading of two seperate workbooks on an userform. As the target directories could be x length is there a way of appending "..." when the label itself isn't big enough to display the path?

If it's going to take a lot of work i'll just leave it as it's more cosmetic and not essential, but if there is something quick and easy i'd really appreciate a nudge in the right direction.

All I can think of is counting and capping the characters and adding it if it exceeds x amount. how I would actually do this is beyond me..

I know I can use something like:

stringlength = Len(lbl_costing_location)
if stringlength > 10 then

But how would I chop of the excess characters and add "..." ???


Thanks in advance for any help

You need to store the full text some where so you can make use of it later.
In order to chop the text use the LEFT function.

One this a fixed length will not take into account is the variable width font being used.

Here is a quick a dirty demo of resizing the label on the fly.
Userform with a Label, textbox and command button.
Enter test text in textbox and press button.

Please Login or Register  to view this content.