PDA

View Full Version : Display worksheet data in user form



tommy1234
08-26-2012, 12:24 AM
hello
i have a worksheet with a pivot table called "analysis" (attached to this post)
i want that the user will be able to press on a command button on another worksheet called "user" and a popup userform will show on screen and will display the data (2 columns from worksheet "analysis") on the userform
the display should be in some kind of grid view

thank you

Teeroy
08-27-2012, 09:41 PM
Try http://www.dailydoseofexcel.com/archives/2004/05/10/populating-multi-column-listboxcombobox/ for some ideas on how to display an array in a listbox. I don't think you can get gridlines in this manner though. If you need gridlines you may need to build a table from label controls which you can set a border around.