Archive for the 'Uncategorized' Category

Jan 23 2008

Enable Text Editing in .NET DataGridViewComboBoxColumn

Published by turlach under Uncategorized

Here’s where the C# version came from: Devolutions.net

And here is the VB version:


   Private Sub dgvMacroGrid_EditingControlShowing(ByVal sender As Object,
            ByVal e As System.Windows.Forms.DataGridViewEditingControlShowingEventArgs)
            Handles dgvMacroGrid.EditingControlShowing
      'Enable text editing in combo cells
      If (dgvMacroGrid.CurrentCellAddress.X = colMacroLookup.DisplayIndex) Then
         Dim cb As ComboBox = CType(e.Control, ComboBox)
         If (cb IsNot Nothing) Then
            cb.DropDownStyle = ComboBoxStyle.DropDown
         End If
      End If
   End Sub

No responses yet

Sep 14 2007

Code signing in VBA

Published by turlach under Uncategorized

On several occasions I have encountered a spurious “Disk Full” Error when trying to save a VBA project after a digital signature was applied. Several online sources suggested that there might be a broken reference (Tools|References). In my case, I had some subroutines in the ThisDocument module that had been used to process clicks on WinForm objects that were later removed from the document. Commenting out those routines solved the problem.

No responses yet

Sep 02 2007

Website readibility

Published by turlach under Uncategorized

Courtesy of a link on digg  is a link to a study showing that most people read web pages in an F shaped pattern, reading the first two paragraphs and then down the left side of the page. Something to consider when adding content to your layout.

No responses yet