Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Alrighty, so I have this code to filter out a combobox and
it works! However there are some complications: 1) Some combo boxes require data from two worksheets from the current workbook. What my does is filter the data from the first worksheet, then process the filtering of hte second worksheet. Then it adds this filtrated value in the combo box. Can someone correct my code so that it will obtain teh data from both worksheets, then filte? I mean it's kind of annoying when it says something like 0 100 300 800 0 20 etc. ya know? 2) Despite the unfiltrated filtration =) my code makes my combobox do something odd. If i were to play my code, the firt time I click the combobox, the values appear fine. However, when I click on the same combobox a second time, it shows twice the data. And if I click it a third time, it shows thrice the original data. Can someone help me fix this problem so that no matter how many times i click the combo box, it'll only show my data one? Here is my filtration code: For i = 1 To NoDupes1.Count - 1 For j = i + 1 To NoDupes1.Count If NoDupes1(i) NoDupes1(j) Then Swap1 = NoDupes1(i) Swap2 = NoDupes1(j) NoDupes1.Add Swap1, befo=j NoDupes1.Add Swap2, befo=i NoDupes1.Remove i + 1 NoDupes1.Remove j + 1 End If Next j Next i Thanks a whole bunch anyone =) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic | Excel Discussion (Misc queries) | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Visual Basic | Excel Discussion (Misc queries) | |||
Visual Basic | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) |