home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,033 of 10,840   
   Rick Rothstein to All   
   Re: MSflexgrid question   
   01 Dec 04 23:45:37   
   
   From: rickNOSPAMnews@NOSPAMcomcast.net   
      
   > I need to clear the grid between updates without clearing   
   > the header row. What is the speediest way to do this?   
      
   What about a subroutine along these lines?   
      
   Sub ClearAllExceptHeaderRow()   
     Dim CurrentRow As Long   
     Dim CurrentCol As Long   
     Dim CurrentRepeatStyle As Long   
     With MSFlexGrid1   
       CurrentRow = .Row   
       CurrentCol = .Col   
       CurrentRepeatStyle = .FillStyle   
       .FillStyle = flexFillRepeat   
       .Row = 1   
       .Col = 0   
       .RowSel = .Rows - 1   
       .ColSel = .Cols - 1   
       .Text = ""   
       .Row = CurrentRow   
       .Col = CurrentCol   
       .FillStyle = CurrentRepeatStyle   
       .SetFocus   
     End With   
   End Sub   
      
   Rick - MVP   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca