A Possibly Simple MsgBox Question...

[Lidsavr]

I am running Excel 2007.

I have written code that does a search of part names after a part number is selected in a listbox. This works great.

I have a MsgBox that displays the information. However, the user cannot copy the information and then paste it into another application.

Is there a way to alter my code so users can do this? Do I need to use something else besides a messagebox?

Here is the portion of the code that creates the msgbox:

    Dim MyVar As String
    Range("I1").Value = MyVar1
    MsgBox ("The name of the part that you are searching is:" & Chr(13) & _
        " " & Chr(13) & MyVar)

Will someone help me figure out what to use to allow users to copy the data provided to them?

Thank you for your help,

Charles

 

[wigi]

Do I need to use something else besides a messagebox?

Yes Charles, you will want to use a userform, that you create and lay out the way to you want. A textbox or label can then contain the text.

 

[Lidsavr]

wigi,
Thanks for your help! I will create the userform!

Regards,

Charles