-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Displaying spreadsheet data in Visual Basic user form?
- Thread starter lincolnho
- Start date
AlphaFrog
MrExcel MVP
- Joined
- Sep 2, 2009
- Messages
- 16,561
When you are in the userform editor, you can right-click on the controls toolbox and select Additional Controls. Select from the list Microsoft Spreadsheet 11.0. This will add a control to the toolbox to allow you to place a mini spreadsheet on your userform.
If you have Excel 2007 or later, you may 1st need to go to Tools\References and select the Microsoft Office Web Components 11.0 library. Then it will show up in your control toolbox Additional Controls list.
If you have Excel 2007 or later, you may 1st need to go to Tools\References and select the Microsoft Office Web Components 11.0 library. Then it will show up in your control toolbox Additional Controls list.
Upvote
0
Thank you, you're amazing. Now that I re-read my question, you did technically answer it. However, I actually mean displaying a set of spreadsheet information that already exists on the current file (like sheet 1, sheet 2, pivot table, etc). I can't seem to find a way to edit that spreadsheet in the Form that I added. Any suggestions?
Upvote
0
