user66
07-09-2010, 09:44 PM
Hello all,
I got an urgent user requirement to implement. User wants to show a userform in Excel spreadsheet, and this form displays a table, which contains a recordset from joined tables in database. Besides each record row, user wants to display a checkbox, so they can chose multiple rows and pass this information to other modules when clicking a button on the form.
I am using MS Excel 2002 SP3. Can anybody please tell me if it is possible to do it in excel VBA? I don't see any datasource controls in the toolbar. If it is possible, can you please guide me how to do it?
Thanks!
I got an urgent user requirement to implement. User wants to show a userform in Excel spreadsheet, and this form displays a table, which contains a recordset from joined tables in database. Besides each record row, user wants to display a checkbox, so they can chose multiple rows and pass this information to other modules when clicking a button on the form.
I am using MS Excel 2002 SP3. Can anybody please tell me if it is possible to do it in excel VBA? I don't see any datasource controls in the toolbar. If it is possible, can you please guide me how to do it?
Thanks!