MrExcel Publishing
Your One Stop for Excel Tips & Solutions

how do i display excel-like grid on a user form?

Posted by ben h on August 14, 2001 4:13 AM

I want to display a row or rows from an excel sheet on a user form, so that it is editable, then be able to read the data back into variables after update by the user.
does anyone know a good control for this?
or do i have to use text boxes?

so far i've tried the DBGrid in DBGRID32.ocx, but i can't get any help for it, and i don't know what it does! i can't use the MS Grid Control (GRID32.ocx), as it says it isn't properly licensed! can anyone help me with this??

Posted by faster on August 14, 2001 12:57 PM

In the VBE you can add additional controls to your
form from the tools menu. Video Soft FlexArray may
be available to you, but you still need to program
the edit capabilities.