1. Jaafar Tribak

    Widening the Dropdown List of an activeX ComboBox to accomodate the longest entry

    Hi dear forum members, As the title says, I have written this code in order to allow the widening of comboboxes dropdowns without the need to make the actual combobox wider. In order to get the most accurate results, the value of the Const : "TUNING_SCALE_CONSTANT" declared at the top of the...
  2. Jaafar Tribak

    Paste event in Excel ? - Half way there.

    Excel_PasteEvent.xls"]Workbook Demo. Hi all. Here is the signature of the paste event handler : Private Sub Workbook__Paste _ (ByVal Target As Object, ByRef Cancel As Boolean) 'prevent pasting into Cell A1. If Not Intersect(Target, Range("a1")) Is Nothing Then Cancel =...

Some videos you may like

This Week's Hot Topics