Using Hidden Sheets to populate listbox

M

MrPebody70

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 char
that shows the info on top at all times.
So all the updating happens in the background without switchin
between sheets.
Secondly I would like to populate a listbox on the form with dat
from a seperate sheet, but so far I haven't been able to figure tha
one out either.
I have taught myself most of what I know, (not much) and ther ar
some holes in my skills. I appreciate any spackle we could put i
those holes.
Thank
 
T

Tom Ogilvy

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
 
Top