PDA

View Full Version : Viewing a range of cells in Excel on a User Form



The"Truth"
12-05-2008, 12:40 PM
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
12-05-2008, 12:43 PM
Probably best to step back a few paces and explain what you are trying to do.

lucas
12-05-2008, 12:46 PM
populates a listbox named SelectHotels on the userform with values from Column A of sheet PropList
Private Sub UserForm_Initialize()
With Sheets("PropList")
SelectHotels.List = Range(.Cells(1, 1), .Cells(1, 1).End(xlDown)).Value
End With
End Sub

It will update each time the userform is opened.

lucas
12-05-2008, 12:46 PM
Yeah Bob, I missed the part about multicolumn......

The"Truth"
12-05-2008, 01:10 PM
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
12-05-2008, 01:22 PM
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
12-05-2008, 02:34 PM
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