Re: Array values into a msgbox
Let me offer you a little advise on how to get people to help you on message boards. Criticizing someone in your quest for help isn't going to make someone want to help you. You're opening line is combative. At the time I posted for assistance, the response from Bill gave me exactly what I needed to get over the hump on the code I was trying to develop. It is not his responsibility to tell me or any poster if I am following the proper rules for coding such as declaring variables. the declaration of variables is something that some very proficient coders never do because other languages do not support/require it. Even something as closely related as VBScript will allow you to declare variable but no the type.
If you are having problems, I would suggest a more cooperative approach. All capitalized words is the equivalent of screaming. Professing your experience with VBA while also asserting that you cannot figure something out again does not inspire me (and I would guess others) to want to help you. The reason is that every time I have heard about how skilled and experienced someone is, they generally don't want to hear what you have to tell them.
If you look at my first posting, I included the code that I had already attempted. It clearly showed that I gave it a fair effort. I asked for ideas on how to improve it and Bill responded. Finally, I thanked Bill for his contribution. Following basic forum etiquette will result in far more meaningful results and assistance.
Quote from brymer;639832Display More
Here's the issue I am having with a lot posts in these forums.
Noone ever defines particular Dimensions for items or code they are offering help on.
For example, OzMVP (Bill) you don't Dim Msg As ?. Is it a string, variant, integer, etc?
I like your code, I tried to use it, but I keep getting the Type Mismatch, which means my values are not what the code is expecting.
I am NOT new to VBA, but I am very raw with Array sets.
Now that I am getting used to the construction, I am having a hard time posting msgbox's to check my tests before plugging into main code.