Create PopUp window with results from excel

[sergiom920]

Hi, I have a spreadhsheet with a bunch of numbers. I would like to create a
button that would then display those numbers as a popup window.

Any ideas?

 

[SteveO59L]

Something like

dim sao1 as string
sao1=range("a1").value
msbox sao1

 

[sergiom920]

I wasnt able to ge the code to work..this line is not working. sao1=range("a1").value

 

[SteveO59L]

What error message do you get?. Worked fine for me.

 

[bartoni]

I believe it should say

msgbox instead of msbox

 

[al_b_cnu]

Hi,

You might also try
sao1=range("a1").Text

 

[sergiom920]

Is there a way to get a range of cells Insted of just one???

 

[al_b_cnu]

hi,

This code will display the contents of A1 thru A5 as separate lines in the messagebox:

Dim R As Range
Dim sText As String
Dim WS As Worksheet

Set WS = Sheets("Sheet1")
For Each R In WS.Range("A1:A5")
    sText = sText & R.Text & vbCrLf
Next R
MsgBox sText

 

[sergiom920]

Does anyone know if there is a way to attach a graph to a comand button to display on a new window???