Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to allow my dropdown to "remember" the value it was on before
..List gets updated and then reposition itself after the update. The code below works perfectly if .List is made up of Strings. However, it does not seem to be working when .List is filled with numbers. I need help thinking my way through this one. I need .List to just be numbers. Any thoughts? Maybe the problem isn't what I think it is. Thanks! -Jeremy ------------------------------------------------------------------------ With UserForm1.Combobox1 ActiveSelection = .Value .Clear For i = 12 To IIf(MoCount 36, 36, MoCount - 1) .AddItem i Next i .ListIndex = IIf(MoCount 36, 12, 0) On Error Resume Next .ListIndex = _ Application.Match(ActiveSelection, Application.Index(.List,0, 1), 0) - 1 On Error GoTo 0 .Enabled = True End With ------------------------------------------------------------------------ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Index Match Problem | Excel Worksheet Functions | |||
Index Match Problem | Excel Worksheet Functions | |||
INDEX OR Match Problem | Excel Worksheet Functions | |||
Possible index/match problem? | Excel Worksheet Functions | |||
Index Match Problem | Excel Worksheet Functions |