neat fix to a gross line of code?

[JimmyWilliams]

Hey guys,

Can someone help make the below better?

Please Login or Register  to view this content.

I really hate this line of code. I would love it if I was able to feed a list of entries when I begin the code, rather then type each of them out like this.
Anyone got an neat fixes?

Please Login or Register  to view this content.

[jindon]

Is it

Please Login or Register  to view this content.

?

[leelnich]

Hi Jimmy, this may not be what you're after, but at least it's shorter:

Please Login or Register  to view this content.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[JimmyWilliams]

Is it

Please Login or Register  to view this content.

?

Almost works except. except Trim doesn't remove hard spaces.

[jindon]

In that case it is not space.

Please Login or Register  to view this content.

[JimmyWilliams]

In that case it is not space.

Please Login or Register  to view this content.

Haven't used "Like" before. I will play around with it. Thanks


Any ideas how I could do the following:
Eg1) User puts in "AR", "pre-start", "1y", "6m"

So something that makes the line look like:

Please Login or Register  to view this content.

Eg2) User puts in "pre-start", "1y", "6m"

So something that makes the line look like:

Please Login or Register  to view this content.

How would I go about doing that, for an indefinite number of user imputs.

[jindon]

How do user inputs those string?

[JimmyWilliams]

hey Jindon,

Below is how users will input:

Please Login or Register  to view this content.

[jindon]

See if this is how you wanted.

Please Login or Register  to view this content.

[JimmyWilliams]

Hey Jindon,

Thanks for the help. This is what I ended up with:
I'm going to play around with your solution in a bit, see if I can learn anything.

My solution:

Please Login or Register  to view this content.

I'm hoping to make the program Ask if they user wants to run the program more then once and accept all the inputs at the very start before it has started running. I think I would need a loop around the following bit of code:

Please Login or Register  to view this content.

***I think I would need a loop and to change my variables to arrays or 2 dimensional collections? I'm not sure how to go about doing that.****

Let me know what you think.

Jimmy.

[JimmyWilliams]

Also

Whenever I run this line:

Please Login or Register  to view this content.

The inputbox has "D:D" in it, why isn't it showing "C4"? What is wrong?


Thanks,
Jimmy

[jindon]

Can you upload a workbook?

I don't understand the reason why you need to sort the collection etc...

[JimmyWilliams]

Can you upload a workbook?

I don't understand the reason why you need to sort the collection etc...

I managed to get this all working.

The "sort collection" part, was so I could have everything alphabetical, and also have similar entries next to each other in the collection, so I could removed them and result in a unique list.

I had to do a second "sort collection" that made sure that the longest strings where searched for first and then the shortest, to prevent accidently having my information go into the wrong category (if the string of the shorter is also found within the longer string, would result in errors).

Anyways, thanks for your help!

Jimmy