PDA

View Full Version : userform displaying table data



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!

user66
07-10-2010, 01:31 AM
Does anyone know the answer? Is VBA the cutdown version of VB, and it cannot implement complicated userforms?

Thanks!