message box too big

Hi,

I am reading all input values and displaying on a "Message box" to confirm from the user.

but, when i get more values and when i display it on a message box. message box becomes too big and i couldnt able to see the "OK" and "Cancel" button.

i am attaching each and every value to a perticular string like here:
msgtotal = msg1 & msg2 & msg3 &............

msgbox "msgtotal"

whats the solution for making a message box fully visible with every values?

please help me
Thanks

You can always design your own "message box" out of a form. This gives you more control over how the data should be displayed as you can put it in controls and frames and make things all pretty like, and you can make sure the data won't overflow and cover up or hide any ok buttons.

How could i design my message box?

do you have anything for me to refer?

thanks

Just take a form and put a label on it, or a textbox, or anything you want to display data in. You need to create a public sub that will fill your controls with provided data, and then you show the form Modally. There really isn't a big mystery, just take a form with an Ok button and a control to display data with. ;)

Thanks for the help but,

sometimes i have total 50-60 values to display and making labels for each and every values will be cumbersome.

Thanks
Nilay

Instead of having them all on the same line you could also use a vbCrLf to add a new line.

MsgBox "1, 2, 3, 4, 5, 6, 7, 8, 9, 10" & vbCrLf & "11, 12, 13, 14, 15 ,16, 17, 18, 19, 20"