Worksheets("Sheet1").Activate
Range("A1").Select
Selection.Value = 3
Range("B9").Select
Selection = 3
Selection.Copy
Worksheets("Sheet2").Activate
Range("C3").Select
Selection.PasteSpecial xlValues

could be done

With Worksheets("Sheet1")
.Range("A1").Value = 3
.Range("B9").Value = 3
worksheets("Sheet2").Range("C3").Value = _
.Range("B9").Value
End With

It wouldn't make any difference what sheet was visible, or if any of the
sheets referenced are hidden or not.

by form do you mean userform?

Private Sub Userform_Initialize()
Userform1.Listbox1.Rowsource = "Sheet1!A1:A10"
End Sub

--
Regards,
Tom Ogilvy


"MrPebody70 " wrote in message
...
Greetings folks,
How do I keep a sheet hidden and still use the data?
I want the end user to use the form I generated and keep the chart
that shows the info on top at all times.
So all the updating happens in the background without switching
between sheets.
Secondly I would like to populate a listbox on the form with data
from a seperate sheet, but so far I haven't been able to figure that
one out either.
I have taught myself most of what I know, (not much) and ther are
some holes in my skills. I appreciate any spackle we could put in
those holes.
Thanks


---
Message posted from http://www.ExcelForum.com/