Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox2.AddItem ListBox1.Value becomes a String when being Integer?
Hi Bob, Tom, ...all other Helping Hands,
I am reading in values (integers & strings) in listbox1 as follows: UserForm1.ListBox1.AddItem Sheets("Sheet1").Cells(Userrange.row, kolom) I make a selection out of Listbox1 into Listbox2 as in sub: AddButton_Click() ===Does my Integer gets converted into String with: ListBox2.AddItem ListBox1.Value ???? and therefore cannot find the Integer in the "Application.Match(ListBox2.List(i), Range(Userrange.Address), 0)"-function?! How to get the same cell "formats" in listbox2 as in listbox1? Sige Private Sub AddButton_Click() Dim i As Integer If ListBox1.ListIndex = -1 Then Exit Sub If Not cbDuplicates Then ' See if item already exists For i = 0 To ListBox2.ListCount - 1 If ListBox1.Value = ListBox2.List(i) Then Beep Exit Sub End If Next i End If ListBox2.AddItem ListBox1.Value End Sub Private Sub OKButton_Click() Dim i As Integer Dim col As Integer Dim iLastRow As Integer Dim Rng As Range MsgBox "The 'To list' contains " & ListBox2.ListCount & " items." For i = 0 To ListBox2.ListCount - 1 MsgBox ListBox2.List(i) col = Application.Match(ListBox2.List(i), Range(Userrange.Address), 0) iLastRow = Cells(Rows.Count, col).End(xlUp).row Set Rng = Range(Cells(AccountOnRow, col), Cells(iLastRow, col)) ActiveWorkbook.Names.Add Name:="VBA" & (i), RefersTo:=Rng Next i Unload Me End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox2.AddItem ListBox1.Value becomes a String when being Integer?
Everything in a listbox is a string. Just convert it to a number to perform
your match Application.Match(clng(ListBox2.List(i)), Range(Userrange.Address),0) Note that sample code may contain syntax errors not introduced by me. -- Regards, Tom Ogilvy "SIGE" wrote in message om... Hi Bob, Tom, ...all other Helping Hands, I am reading in values (integers & strings) in listbox1 as follows: UserForm1.ListBox1.AddItem Sheets("Sheet1").Cells(Userrange.row, kolom) I make a selection out of Listbox1 into Listbox2 as in sub: AddButton_Click() ===Does my Integer gets converted into String with: ListBox2.AddItem ListBox1.Value ???? and therefore cannot find the Integer in the "Application.Match(ListBox2.List(i), Range(Userrange.Address), 0)"-function?! How to get the same cell "formats" in listbox2 as in listbox1? Sige Private Sub AddButton_Click() Dim i As Integer If ListBox1.ListIndex = -1 Then Exit Sub If Not cbDuplicates Then ' See if item already exists For i = 0 To ListBox2.ListCount - 1 If ListBox1.Value = ListBox2.List(i) Then Beep Exit Sub End If Next i End If ListBox2.AddItem ListBox1.Value End Sub Private Sub OKButton_Click() Dim i As Integer Dim col As Integer Dim iLastRow As Integer Dim Rng As Range MsgBox "The 'To list' contains " & ListBox2.ListCount & " items." For i = 0 To ListBox2.ListCount - 1 MsgBox ListBox2.List(i) col = Application.Match(ListBox2.List(i), Range(Userrange.Address), 0) iLastRow = Cells(Rows.Count, col).End(xlUp).row Set Rng = Range(Cells(AccountOnRow, col), Cells(iLastRow, col)) ActiveWorkbook.Names.Add Name:="VBA" & (i), RefersTo:=Rng Next i Unload Me End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox2.AddItem ListBox1.Value becomes a String when being Integer?
Hi Tom, Thanks!!! A subtle piece of art! :o))) Sige "NOSPAM" to be removed for direct mailing... *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with: ListBox1.AddItem (ws.Name) | Excel Worksheet Functions | |||
Listbox1 to Listbox2? | Excel Programming | |||
Userform - Populate Listbox2 based on selection in Listbox1 | Excel Programming | |||
listbox1.additem syntax for multiple columns | Excel Programming | |||
(Worksheet)Listbox1.additem = (Form)Listbox1.value ?? | Excel Programming |