Results 1 to 6 of 6

Thread: Userform With DataGrid or FlexGrid

  1. #1
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    Userform With DataGrid or FlexGrid

    I need a data grid on my userform - but data grids & flexgrids are not trusted - according to Mr Gates - what is a good grid to use on a userform. I need the grid for input of user settings - needs to be dynamic - so dont want to use textboxes
    Last edited by Rasm; 04-08-2011 at 03:07 AM.
    xl2007 - Windows 7
    xl hates the 255 number

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Rasm, you could use any of GridView or FlexGrid. The problem is not the trust, it's with portability. If you do not plan to use it on multiple versions of the office application, you could go with either of these.

    However, one would think a safer bet would be to go with textboxes. Even if you wanted it to be dynamic, there could still be ways to put in a dynamic code which can replace the need of a Grid.

  3. #3
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    Is gridview a third party usercontrol ? - I did use itGrid - absolutely the best - but they went out of bussiness. So I am a bit leary of third party OCXs
    xl2007 - Windows 7
    xl hates the 255 number

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    It is not third party.

  5. #5
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    How is the GridView listed under the list of controls - I cannot find it - sorry - maybe I am half blind or something:o
    xl2007 - Windows 7
    xl hates the 255 number

  6. #6
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Microsoft DataGrid Control 6.0 (SP6) OLEDB

Similar Threads

  1. One userform and 60 Combo Boxes
    By k0st4din in forum Excel Help
    Replies: 11
    Last Post: 04-25-2013, 09:55 AM
  2. set ListView on userform
    By Mahesh in forum Excel Help
    Replies: 3
    Last Post: 12-04-2012, 08:50 AM
  3. Multiple graph in userform
    By Tony in forum Excel Help
    Replies: 3
    Last Post: 10-20-2012, 09:32 AM
  4. Scrolling Marquee text on Userform
    By Mechanic in forum Excel Help
    Replies: 1
    Last Post: 12-08-2011, 07:24 AM
  5. FreezePane In A Userform SpreadSheet Control 11.0
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 05-15-2011, 05:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •