listbox error

In my program if the user does not proceed with the correct method of clicking the row in a listbox to select the row and then click on the delete row button, error message 381 is shown. if the user now clicks on "End" button the form totally closes and the login window is shown. if the user...

Hello everyone! Hopefully you can help me with this and I'm just missing something really simple :nya: I'm having an issue with a worksheet I have pasted into a PowerPoint slide using Paste Special>Paste Link>Microsoft Excel Worksheet (code) Object. The trouble is in the worksheet I have a...

I am using an Active-X listbox on my worksheet and trying to add items but having a problem trying to insert the last item. I'm getting a run-time error. Here is what part of the code looks like: For r = 3 To rowCount If Sheets("Sheet2").Range("B" & r).Value = ComboBox1.Value Then...

I'm trying to add items to a listbox, but get a runtime error on the last item: ... ListBox2.List(i, 0) = Sheets("Sheet2").Range("B" & r).Value ListBox2.List(i, 1) = Sheets("Sheet2").Range("C" & r).Value ListBox2.List(i, 2) = Sheets("Sheet2").Range("E" &...

I have setup a Listbox with the following properties: fmListSyleOption, fmMultiSelectMulti, ColumnCount=3. Here is the code: For r = 3 To rowCount If Sheets("Sheet1").Range("B" & r).Value = ComboBox1.Value Then ListBox2.List(i, 0) =...

Hi, I am having problems with populating 11 columns in my ListBox6. The following code gives me a Run-Time error 380 "Could not set the List property. Invalid property value." when I am creating column 11 .List(.ListCount - 1, 10) = Me.ListBox5.List(x, 8) . If I were to remove the statement...