macro dropdown

  1. S

    Making 2 Dependable drop downs

    Sub Test() 'drop down list Dim language As Variant Dim team As Variant language = [{"KA", "KT", "PJ", "TU"}] ' assign value 'put in K2 array language With Range("K2").Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, _ Operator:=xlBetween...
  2. O

    Need help with this macro

    '========================== Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _ Cancel As Boolean) Dim str As String Dim cboTemp As OLEObject Dim ws As Worksheet Set ws = ActiveSheet Cancel = True Set cboTemp = ws.OLEObjects("TempCombo") On Error Resume Next With cboTemp...

Some videos you may like

This Week's Hot Topics