Pop up containing information from worksheet in excel

[9657703]

Hi,

I need assistance with creating a pop up box that will display information in excel. I need to read the values (could be YES or NO) from the sheet in a certain range/column (e.g. A1 to A15). The corresponding information will then be displayed in the pop up box on open.

E.g.
[IMG]c:\users\nadeem\pictures\excel.jpg[/IMG]


So far I only got the following code;

 Private Sub Workbook_Open()
     MsgBox "This is a test box", vbInformation, "Outstanding"
End Sub

Please email me at [e-mail]

Nadeem.

[kadghar]

Hi,

I need assistance with creating a pop up box that will display information in excel. I need to read the values (could be YES or NO) from the sheet in a certain range/column (e.g. A1 to A15). The corresponding information will then be displayed in the pop up box on open.

Nadeem.

hi there,

I will asume you're working in Excel's VBA

this little example will save the values from cells A1 to A15 into a string, and then put it into a msgbox.

sub test()
dim i as integer
dim Str1 as string
for i = 1 to 15
    str1 = str1 & cells(i,1).value & " "
next
msgbox str1
end sub

HTH

PS, dont put your personal email