Insertbefore an array? help :(

macropod · #1 08-15-2014, 10:39 PM

Did you read all of post #6? It contains instructions for how to limit the box to just the "vowel" & ChrW(9700) & "consonant".

To include one or more consecutive preceding vowels, simply change "[aeiouy]" to "[aeiouy]{1,}". If you want to be selective about which preceding vowel combinations it will accept, a different approach will been needed, but I'd need to know exactly which every one of those vowel combinations is - I don't propose to try to decipher them from the abysmal '.Text =' expression in your last post.

In the meantime, you might try:

Code:

    .Text = "[aeiouyæ" & ChrW(593) & ChrW(596) & ChrW(601) & ChrW(604) & ChrW(618) & ChrW(650) & ChrW(652) & "]{1,}" _
      & ChrW(9700) & _
      "[!^32-^62\?\@aeiouyæ" & ChrW(593) & ChrW(596) & ChrW(601) & ChrW(604) & ChrW(618) & ChrW(650) & ChrW(652) & "]"

Finally, as already requested in post #2, please use the code tags when posting code.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding information from a array into a table	jcorti	Word VBA	4	01-10-2014 10:58 PM
Convert String Array to Integer Array from a User Input?	tinfanide	Excel Programming	4	12-26-2012 08:56 PM
Complex array formula	andrei	Excel	9	02-03-2012 03:40 AM
How to capture start and ending Ref. Nos. in an array	KIM SOLIS	Excel	5	09-07-2011 07:43 AM
Look up an array based on user input	johnsmb	Excel	2	01-07-2011 01:12 PM