Msgbox more than 2014 Characters

[Ravana]

Hi all,

I using a code to display a array of texts which sometimes increases more than 1024 characters that Msgbox can accommodate.

If the result is Morethan 1023 characters, it is getting truncated. So I am hoping for a workaround.

Please help.

Please Login or Register  to view this content.

[sweep]

Hi,

You could create a userform, add a label, resize it and set the caption property to your variable in the userform_initialize module

Call the userform with something like

Please Login or Register  to view this content.

The 1 after the show command makes the form modal - ie, it needs to be closed before focus can be passed to another window.

[Ravana]

Hi sweep,

I am not adept at vb, can you please be more elaborate.

[Ravana]

Hi sweep,

I am not adept at vb, can you please be more elaborate.

[Ravana]

I tried creating a user form but nothing happened, I get a blank box.

Please Login or Register  to view this content.

[sweep]

No problem.

In the vba editor, add a user form:

Insert > UserForm

You will be presented with a window containing a blank userform, and a floating "Toolbox" window (if you don't see this, open it from the View menu)

Add a label to the userform that occupies the majority of the blank space by clicking the label icon (a capital A) on the toolbox menu and then clicking and dragging on the userform. In the top left corner you should see "Label1"

In the project explorer frame, select UserForm1 and then click

View > Code

In the object dropdown (Probably showing "(General)" select UserForm1
In the procedure dropdown (Probably showing "Click" select Initialize

Edit the Private Sub UserForm_Initialize() as follows:

Please Login or Register  to view this content.

Change your original code as follows:

Please Login or Register  to view this content.

[Ravana]

@Sweep, that was awesome.

I am using userform to display few account heads which sometimes take more than 50 lines. However userform capacity is limited by Lable1 size (as much as I can drag). Can I add scroll so that all the lines are visible instead of limiting to size of label?

[romperstomper]

What do you expect the user to do with all this information?

[sweep]

No scrollbars for a label (note that you could drag the corner to change the size of the userform and the label)

Failing that you'd need to look at maybe a text box, or a combo box on the userform instead.

[Ravana]

I am looking at anything that can be useful to me. If Userform doesn't than as you suggest I would be happy to use text box but only I do not know, how to do that.

Can you please help me.

[sweep]

Take a look at user form tutorials such as these

http://www.excel-easy.com/vba/userform.html
http://www.excel-vba.com/excel-vba-s...s-advanced.htm

which should start you on a road to a solution.