get info form another sheet using command button???

[khelbert]

I have a command button on sheet 1, that when it is pushed I need it to pull up a "pop up" - "message" box with the info form sheet 20 .

Can this be done and how??

[techyspecy]

Originally posted by khelbert
I have a command button on sheet 1, that when it is pushed I need it to pull up a "pop up" - "message" box with the info form sheet 20 .

Can this be done and how??

What are we talking about here ? VB or Excel ?

[Sgt-Peppa]

Dim ws as Worksheet
Dim tmp as String
 
tmp = ws.worksheets(20).range("a",1)
msgbox tmp

worksheets(put the number of the worksheet you want information from here).range(put the cells your want the information from here)

I did not test this, just an idea to get you on the right track,


Hope I could help,


Stephan

[khelbert]

the worksheet is Excel, but I have use VB for the buttons, check boxes and etc. I have the VB code to make the button take me to sheet 20 but I only want the info on that page to come up in a "pop up" message window - not take me to that page.