Using Hidden Sheets to populate listbox
 

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

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

Using Hidden Sheets to populate listbox
 

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/