Capture array into message box

[jprlimey]

First, I want to put the following array into a message box.

Please Login or Register  to view this content.

Second, after the user has completed the revisions/edits to the user form inputs, i want to capture all the users selections from the combo boxes, text boxes and option buttons, is their a simple way to put this into an array so that the beginning array can be compared to the ending array?

Thanks

[Vikas_Gautam]

Hi
for capturing array to a msgbox..

try following code.... after end with

Please Login or Register  to view this content.

Don't forget to click *

[jprlimey]

Vikas,

Thank you for the suggestion.

I tried your slution the message box does show but is completely blank, any thoughts?

Thanks

[Andy Pope]

You need to modify your other code as you are not storing any information in the array.

Please Login or Register  to view this content.

[Vikas_Gautam]

Hi jprlimey,

change your code.. as per Andy's Suggestion..

and then try running my code..

hopefully you will get the results...



Don't forget to click *

[jprlimey]

Andy,

Thank you for the reply.

When i step thru the macro using the debug mode "step into", i can clearly see that the myVar(s) are loading with the correct information, so i'm not sure how it is not storing the infromation. So how do you suggest that i change the macro, any help would be appreciated.

Thanks

[jindon]

Please Login or Register  to view this content.

[Leith Ross]

Hello jprlimey,

A message box can display only about 1024 characters in total. Your array may not display all it's the information.

[jprlimey]

Leith,

That is a good point about the message box maximum size of 1024 characters. In this case if some of the variables are empty and nothing shows does that count towards the 1024 characters?

Thanks

[jprlimey]

Jindon,

The suggestions worked great, the message box displays everything.

Now i tried to capture what the user may have changed, for this i created another sub routine that is called just before the user form selections are placed onto the worksheet. See below, this is not the entire variables i truncated them for ease of discussion and only show 1 thru 6.

I tried to declare the myVerify as both String and Variant but neither worked. I though that the values that the user slected through the combo and text boxes would be still available to place into an array being that i called this sub routine within the initial sub routine, any thoughts?

Please Login or Register  to view this content.

[jprlimey]

Jindon,

The suggestions worked great, the message box displays everything.

Now i tried to capture what the user may have changed, for this i created another sub routine that is called just before the user form selections are placed onto the worksheet. See below, this is not the entire variables i truncated them for ease of discussion and only show 1 thru 6.

I tried to declare the myVerify as both String and Variant but neither worked. I though that the values that the user slected through the combo and text boxes would be still available to place into an array being that i called this sub routine within the initial sub routine, any thoughts?

Please Login or Register  to view this content.

[jindon]

You are not assigning values to the array.

Please Login or Register  to view this content.

[jprlimey]

Jindon,

I see my mistake, thanks for helping me along. I going to close this post as Solved.

Thanks