View Single Post
 
Old 11-13-2020, 03:57 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

This is VBA we are talking about here. Perhaps other programming languages change the value of a variable just by asking for a characteristic of that variable's value but it doesn't happen in VBA.

The value of the variable 'wrd' is not being changed by your line
Select Case Trim(wrd)

If you want to change the value of the text in wrd then you need to tell it to change
eg
wrd = Trim(wrd)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote