View Single Post
 
Old 06-02-2025, 11:22 PM
victorybadges victorybadges is offline Windows 10 Office 2013
Advanced Beginner
 
Join Date: Dec 2020
Posts: 39
victorybadges is on a distinguished road
Default

thank you for the latest instructions
the result was a colon prefix and dots instead of spaces which I have been able to remove by replacing this
StrTxt = Split(.SelectedItems(j), "")(UBound(Split(.SelectedItems(j), "")))
StrTxt = ": " & Left(StrTxt, InStrRev(StrTxt, "."))

with this

StrTxt = Split(.SelectedItems(j), "")(UBound(Split(.SelectedItems(j), "")))
StrTxt = Left(StrTxt, InStrRev(StrTxt, "."))

but its still producing a dot as a suffix at the end of the caption
also the caption is showing bottom row while it should be position on the top
I cannot attach an image
Reply With Quote