Viewing a range of cells in Excel on a User Form

[The"Truth"]

How do I view a range of cells on a User form? I have a range of cells A3:J18 and all I want to do is view them on a user form. One more question will these values update on the user form as they update on the Excel page?

[Bob Phillips]

Probably best to step back a few paces and explain what you are trying to do.

[lucas]

populates a listbox named SelectHotels on the userform with values from Column A of sheet PropList
[VBA]Private Sub UserForm_Initialize()
With Sheets("PropList")
SelectHotels.List = Range(.Cells(1, 1), .Cells(1, 1).End(xlDown)).Value
End With
End Sub
[/VBA]
It will update each time the userform is opened.

[lucas]

Yeah Bob, I missed the part about multicolumn......

[The"Truth"]

I am trying to set up a User form where a production associate is entering in data to the form. I have several tabs on the user form and I was trying to allow the production associate to view a querie in excel so he can determine the amount of parts to run to complete the batch.

[Bob Phillips]

Personally, that adds nothing to my knowledge.

Tell us about the worksheet, the layout, the data. Tell us about the process, what the user will do. Tell us about the layout of theinfo, the data.

[Dave]

Jaafar's frame control on a userform works very well if you just need to view a range on a userform. To update the "picture" of the range on the userform just re-run the procedure. HTH. Dave
http://www.mrexcel.com/forum/showthread.php?t=176704