Here is what I would like to have happen. I have a listbox that is for listing the quantity an item that is selected by the user. I want the up arrow to increase the quantity so I have to load the listbox in reverse order which I was able to do, but I want to start with a quantity of "1" so when I set the value after the listbox is loaded, the value is in inverted colors (i.e. forecolor is what, backcolor is black) and no matter what I do, I can't change that. So any ideas on solutions as I don't want the different colors. Here is the code:
FindItemQtyIndex = 0
lstbxManualEntryItemQty.RowSourceType = "Value List"
Do
DisplayFindItemQtyIndex = FindItemQtyTotal - FindItemQtyIndex
FindItemQtyIndex = FindItemQtyIndex + 1
FindItemQtyIndexAsString = DisplayFindItemQtyIndex
If DisplayFindItemQtyIndex < 10 Then
FindItemQtyIndexAsString = Chr(34) & Space(2) & FindItemQtyIndexAsString & Chr(34)
End If
lstbxManualEntryItemQty.AddItem (FindItemQtyIndexAsString)
If FindItemQtyIndex = FindItemQtyTotal Then Exit Do
Loop
lstbxManualEntryItemQty.ForeColor = vbBlack
lstbxManualEntryItemQty.BackColor = vbWhite
lstbxManualEntryItemQty.Value = " 1"