Find & Replace query

I'm just wondering, is there a way of coding a textbox to search for certain words and automatically changing their case...?

An example,

The user types out a paragraph in which he specifies a street, e.g. lime avenue, or a name e.g. roger federer, or an address, e.g. flat 14, new cut road, plymouth, sg4 3xb.

Within this paragraph the user wants the above entries to appear as follows,

LIME AVENUE, i.e. all UpperCase
Roger FEDERER, i.e. First name ProperCase, lastname UpperCase
FLAT 14, NEW CUT ROAD, PLYMOUTH, SG4 3XB. i.e. all UpperCase

Can this be achieved?

Some problems I forsee....

A search could be created to look for "road" or "avenue" or "street".....but what about the word preceeding it, i.e. lime avenue, or what if there are more than one word, i.e. new cut road?

Also, what if the name was "**** view", since you can also 'view' something...but wouldn't want every instance of view capitalised?

In terms of the persons name...there could be an almost infinite number of permutations, as with address?

Therefore what about the user placing some kind of indication with each word(s) of interest...something for the search to look out for, for example

*lime avenue*, *flat 14, new cut road, plymouth, sg4 3xb*, and #roger federer#, where anything between *'s would be capitalised, and everything between #'s would be first word ProperCase, second word UpperCase...also where hyphenated words count as one, i.e. hunting-smythe.

The find and replace feature in Word could be utilised once the text makes it into a document but the user would have to search each one in turn surely?


Any thoughts?

This may be stating the obvious but when you say 'complete lookup list' do you mean you would need to list EVERY example that you would likely come across? As it is down to the inputter(s) to complete the textbox there could be any number of possibilities...

Hmmm..ok

Everything is inputted into lowercase therefore you will only ever need to capitalise certain words or strings....

I understand the logic of the lookup list but I can't see how it could be achieved, for the reasons we agree on above.

Could there possibly be a way of 'flagging up' the relevant words/ strings within the text in order to give the routine something to look for, in the absence of a definitive list? Such as by placing a certain character at either end of the words or string to identify it, as suggested above.

How might one go about doing that then, say by using *Firstname LASTNAME* and #ROAD NAME#, #FULL ADDRESS#. Case as shown. Stars and hash marks would not be used anywhere else.

I agree, by the time you've highlighted the letter you might as well just do it. I've just thought of another too, the letter "i".

I'll do some research and no doubt come back to you when I hit the wall.

I have read around the subject and am familiar with the following,

Please Login or Register  to view this content.

However, this is geared to text found in the document and not the textbox that is being inputted and the selection element means you have to specify each word to look for. How can it be adapted to search for highlighted words in a range, in the textbox?

EverythingI have found seems to be a variation on the above only.

Oh, ok. Thats makes things a little clearer then....and I could do every section as I go, although it would make sense to do all sections together in one pass once all the information has been entered. It is only the main body of text to cover...no headers footers or anything like that.

ok - it's straightforward to find & replace a single word in the document....however it gets a bit tedious when repeating for "x" number of words....which would also need hard coding....hence Macropods suggestion of a textfile to hold the data to refer to.

Trouble is doing this to search for anything between two characters (which indicate that everything between needs to be replaced). I have seen many many instances where people have asked similar questions...n the one or two examples that appear to have solutions I simply get lost with some of the coding...and i must admit that my head is throbbing at the moment.

I love the logic behind it all....but the language escapes me!

YES, unless of course you know what you're looking at!

It doesn't matter.....I feel like a plummer trying to re-wire a house (having had a quick look at a manual)!!!

I'm sorry...

I kind of get what's going on, but not enough to be able to adapt it and incorporate it into my userform to suit my needs.

Cheers though,

As attached....

As always....works fine....thank you.