Query Excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fidell
    New Member
    • Aug 2007
    • 3

    Query Excel

    Please how do query(select some fields) in excel worksheet to display in a grid and textboxes in vb form? How do i avoid the error "invalid use of null" since some of the fields will be blank before values are entered through the textbox?
  • kadghar
    Recognized Expert Top Contributor
    • Apr 2007
    • 1302

    #2
    Originally posted by Fidell
    Please how do query(select some fields) in excel worksheet to display in a grid and textboxes in vb form? How do i avoid the error "invalid use of null" since some of the fields will be blank before values are entered through the textbox?
    It depends if you're using VB or VBA, and if it's an object with an application or the workbook where you have the code.

    Can you give that information?

    Comment

    Working...