Hi,
I am trying to make my very long code more efficient as it becoming a challenge to maintain. The basic portions of the code are as follows:
A userform pops up to ask the user for sets of words seperated by commas. Here is the relevant userform code:
In a regular module, I have code that will split the words from each array:Please Login or Register to view this content.
and then look for each word in a range and modify these words if found:Please Login or Register to view this content.
The actual userform and code currently contains seven sets of commands (one corresponding to each textbox on the userform. Therefore each time I make one modification, to the code, I have to make sure I modify it seven times and then test it seven times to make sure I coded it correctly each time. The number of textboxes on the userform is going to increase and I need help finding a better way to manage all this code.Please Login or Register to view this content.
I tried using:
and same thing for the variant (a) in "myList_1(a)" but I am having no luck coding it correctly.Please Login or Register to view this content.
If anyone has experience with these issues, could you please guide me so I can modify my code accordingly?
Thanks.
abousetta
Bookmarks