Listbox not showing the values that were populated in it using Listbox.List method












1















After running the Userform_Initialize() event, there would be nothing populated in the listbox as shown below:



enter image description here



There should be 11 columns populating the listbox based on the excel table below:



enter image description here



The code ran:



Private Sub UserForm_Initialize()

Dim Total_rows_FoilProfile As Long
Dim row As Range, i As Long

Total_rows_FoilProfile = TotalRowsCount(ThisWorkbook.Name, "Foil Profile", "tblFoilProfile")

ReDim MyArr(0 To Total_rows_FoilProfile - 1)

For Each row In ThisWorkbook.Worksheets("Foil Profile").ListObjects("tblFoilProfile").Range.SpecialCells(xlCellTypeVisible).Rows
MyArr(i) = row.Value
i = i + 1
Next row

lbxFoilInfoDisplay.List = MyArr

frmFoilPanel.Show


The properties of the listbox:



enter image description here



enter image description here










share|improve this question























  • @K.Dᴀᴠɪs Thanks that makes sense, but how do I populate the listbox with the table above though? Does it makes sense if I make a nested for-next loop that loops through the row and columns so each cell in the table would be assigned to one cell in the array instead? Will the Listbox.list method work from there if I assign to it MyArr(5, 11)?

    – Pherdindy
    Nov 20 '18 at 8:03













  • @K.Dᴀᴠɪs Yes actually, the combo boxes shown in the userform acts like a filtering mechanism that dynamically updates the listbox which i'll fire using the After_Update() events of each combo box but I don't know how to populate the list using VBA because RowSource method uses an excel string formula as an argument which will not work because i'm using Autofilter. I have a work around of having a helper worksheet use PasteSpecial then use that as my listbox input, but I believe it's computationally taxing given I have to update that worksheet for each combo box that is updated

    – Pherdindy
    Nov 20 '18 at 8:09


















1















After running the Userform_Initialize() event, there would be nothing populated in the listbox as shown below:



enter image description here



There should be 11 columns populating the listbox based on the excel table below:



enter image description here



The code ran:



Private Sub UserForm_Initialize()

Dim Total_rows_FoilProfile As Long
Dim row As Range, i As Long

Total_rows_FoilProfile = TotalRowsCount(ThisWorkbook.Name, "Foil Profile", "tblFoilProfile")

ReDim MyArr(0 To Total_rows_FoilProfile - 1)

For Each row In ThisWorkbook.Worksheets("Foil Profile").ListObjects("tblFoilProfile").Range.SpecialCells(xlCellTypeVisible).Rows
MyArr(i) = row.Value
i = i + 1
Next row

lbxFoilInfoDisplay.List = MyArr

frmFoilPanel.Show


The properties of the listbox:



enter image description here



enter image description here










share|improve this question























  • @K.Dᴀᴠɪs Thanks that makes sense, but how do I populate the listbox with the table above though? Does it makes sense if I make a nested for-next loop that loops through the row and columns so each cell in the table would be assigned to one cell in the array instead? Will the Listbox.list method work from there if I assign to it MyArr(5, 11)?

    – Pherdindy
    Nov 20 '18 at 8:03













  • @K.Dᴀᴠɪs Yes actually, the combo boxes shown in the userform acts like a filtering mechanism that dynamically updates the listbox which i'll fire using the After_Update() events of each combo box but I don't know how to populate the list using VBA because RowSource method uses an excel string formula as an argument which will not work because i'm using Autofilter. I have a work around of having a helper worksheet use PasteSpecial then use that as my listbox input, but I believe it's computationally taxing given I have to update that worksheet for each combo box that is updated

    – Pherdindy
    Nov 20 '18 at 8:09
















1












1








1


1






After running the Userform_Initialize() event, there would be nothing populated in the listbox as shown below:



enter image description here



There should be 11 columns populating the listbox based on the excel table below:



enter image description here



The code ran:



Private Sub UserForm_Initialize()

Dim Total_rows_FoilProfile As Long
Dim row As Range, i As Long

Total_rows_FoilProfile = TotalRowsCount(ThisWorkbook.Name, "Foil Profile", "tblFoilProfile")

ReDim MyArr(0 To Total_rows_FoilProfile - 1)

For Each row In ThisWorkbook.Worksheets("Foil Profile").ListObjects("tblFoilProfile").Range.SpecialCells(xlCellTypeVisible).Rows
MyArr(i) = row.Value
i = i + 1
Next row

lbxFoilInfoDisplay.List = MyArr

frmFoilPanel.Show


The properties of the listbox:



enter image description here



enter image description here










share|improve this question














After running the Userform_Initialize() event, there would be nothing populated in the listbox as shown below:



enter image description here



There should be 11 columns populating the listbox based on the excel table below:



enter image description here



The code ran:



Private Sub UserForm_Initialize()

Dim Total_rows_FoilProfile As Long
Dim row As Range, i As Long

Total_rows_FoilProfile = TotalRowsCount(ThisWorkbook.Name, "Foil Profile", "tblFoilProfile")

ReDim MyArr(0 To Total_rows_FoilProfile - 1)

For Each row In ThisWorkbook.Worksheets("Foil Profile").ListObjects("tblFoilProfile").Range.SpecialCells(xlCellTypeVisible).Rows
MyArr(i) = row.Value
i = i + 1
Next row

lbxFoilInfoDisplay.List = MyArr

frmFoilPanel.Show


The properties of the listbox:



enter image description here



enter image description here







excel vba excel-vba listbox






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 20 '18 at 7:47









PherdindyPherdindy

27117




27117













  • @K.Dᴀᴠɪs Thanks that makes sense, but how do I populate the listbox with the table above though? Does it makes sense if I make a nested for-next loop that loops through the row and columns so each cell in the table would be assigned to one cell in the array instead? Will the Listbox.list method work from there if I assign to it MyArr(5, 11)?

    – Pherdindy
    Nov 20 '18 at 8:03













  • @K.Dᴀᴠɪs Yes actually, the combo boxes shown in the userform acts like a filtering mechanism that dynamically updates the listbox which i'll fire using the After_Update() events of each combo box but I don't know how to populate the list using VBA because RowSource method uses an excel string formula as an argument which will not work because i'm using Autofilter. I have a work around of having a helper worksheet use PasteSpecial then use that as my listbox input, but I believe it's computationally taxing given I have to update that worksheet for each combo box that is updated

    – Pherdindy
    Nov 20 '18 at 8:09





















  • @K.Dᴀᴠɪs Thanks that makes sense, but how do I populate the listbox with the table above though? Does it makes sense if I make a nested for-next loop that loops through the row and columns so each cell in the table would be assigned to one cell in the array instead? Will the Listbox.list method work from there if I assign to it MyArr(5, 11)?

    – Pherdindy
    Nov 20 '18 at 8:03













  • @K.Dᴀᴠɪs Yes actually, the combo boxes shown in the userform acts like a filtering mechanism that dynamically updates the listbox which i'll fire using the After_Update() events of each combo box but I don't know how to populate the list using VBA because RowSource method uses an excel string formula as an argument which will not work because i'm using Autofilter. I have a work around of having a helper worksheet use PasteSpecial then use that as my listbox input, but I believe it's computationally taxing given I have to update that worksheet for each combo box that is updated

    – Pherdindy
    Nov 20 '18 at 8:09



















@K.Dᴀᴠɪs Thanks that makes sense, but how do I populate the listbox with the table above though? Does it makes sense if I make a nested for-next loop that loops through the row and columns so each cell in the table would be assigned to one cell in the array instead? Will the Listbox.list method work from there if I assign to it MyArr(5, 11)?

– Pherdindy
Nov 20 '18 at 8:03







@K.Dᴀᴠɪs Thanks that makes sense, but how do I populate the listbox with the table above though? Does it makes sense if I make a nested for-next loop that loops through the row and columns so each cell in the table would be assigned to one cell in the array instead? Will the Listbox.list method work from there if I assign to it MyArr(5, 11)?

– Pherdindy
Nov 20 '18 at 8:03















@K.Dᴀᴠɪs Yes actually, the combo boxes shown in the userform acts like a filtering mechanism that dynamically updates the listbox which i'll fire using the After_Update() events of each combo box but I don't know how to populate the list using VBA because RowSource method uses an excel string formula as an argument which will not work because i'm using Autofilter. I have a work around of having a helper worksheet use PasteSpecial then use that as my listbox input, but I believe it's computationally taxing given I have to update that worksheet for each combo box that is updated

– Pherdindy
Nov 20 '18 at 8:09







@K.Dᴀᴠɪs Yes actually, the combo boxes shown in the userform acts like a filtering mechanism that dynamically updates the listbox which i'll fire using the After_Update() events of each combo box but I don't know how to populate the list using VBA because RowSource method uses an excel string formula as an argument which will not work because i'm using Autofilter. I have a work around of having a helper worksheet use PasteSpecial then use that as my listbox input, but I believe it's computationally taxing given I have to update that worksheet for each combo box that is updated

– Pherdindy
Nov 20 '18 at 8:09














1 Answer
1






active

oldest

votes


















2














You can populate each list row and then add the columns to it:



Option Explicit

Private Sub UserForm_Initialize()
Dim tblFoilProfile As ListObject
Set tblFoilProfile = ThisWorkbook.Worksheets("Foil Profile").ListObjects("tblFoilProfile")

Dim i As Long

lbxFoilInfoDisplay.Clear

Dim iListRow As Range
For Each iListRow In tblFoilProfile.DataBodyRange.SpecialCells(xlCellTypeVisible).Rows
With Me.lbxFoilInfoDisplay
.AddItem iListRow.Cells(1, 1).Value 'add first value (column 1)

Dim iCol As Long
For iCol = 2 To iListRow.Columns.Count 'add all other columns to that row
.list(i, iCol) = iListRow.Cells(1, iCol).Value '.Value for unformatted value or .Text to show it in the same format as in the cell
Next iCol
i = i + 1
End With
Next iListRow
End Sub


Note here is a nice guide how to work with list objects.






share|improve this answer


























  • I am getting a Could not set the List property. Invalid property value. When iCol = 10 and iListRow = 0 at the .list(i, iCol) = iListRow.Cells(1, iCol).Value using the data table shown above for some reason. I never knew you could populate a list similarly to an array though and that it starts at row 0. Thanks

    – Pherdindy
    Nov 20 '18 at 8:40













  • I'll check around on my data maybe there's some format that makes it unable to add to the list. But I think this should work

    – Pherdindy
    Nov 20 '18 at 8:52






  • 1





    Check the value of iListRow.Cells(1, iCol).Value when the error occurs. This should work. I assume there is an error in the cell. Use either .list(i, iCol) = CStr(iListRow.Cells(1, iCol).Value) or .list(i, iCol) = iListRow.Cells(1, iCol).Text (to show the value in the same format as it was shown in the cell).

    – Pᴇʜ
    Nov 20 '18 at 8:53













  • Thanks still working on finding why it's failing. I tried the other two to try convert it to string, but still the same issue. But what's weird is that it's the same text of TEST could the listbox have a limit on the number of columns? I found this there is indeed a 9 column limit mrexcel.com/forum/excel-questions/…

    – Pherdindy
    Nov 20 '18 at 9:11








  • 1





    @Pherdindy Note that you don't even need to loop to copy the filtered range. Which makes it even easier.

    – Pᴇʜ
    Nov 20 '18 at 9:25











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53388381%2flistbox-not-showing-the-values-that-were-populated-in-it-using-listbox-list-meth%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









2














You can populate each list row and then add the columns to it:



Option Explicit

Private Sub UserForm_Initialize()
Dim tblFoilProfile As ListObject
Set tblFoilProfile = ThisWorkbook.Worksheets("Foil Profile").ListObjects("tblFoilProfile")

Dim i As Long

lbxFoilInfoDisplay.Clear

Dim iListRow As Range
For Each iListRow In tblFoilProfile.DataBodyRange.SpecialCells(xlCellTypeVisible).Rows
With Me.lbxFoilInfoDisplay
.AddItem iListRow.Cells(1, 1).Value 'add first value (column 1)

Dim iCol As Long
For iCol = 2 To iListRow.Columns.Count 'add all other columns to that row
.list(i, iCol) = iListRow.Cells(1, iCol).Value '.Value for unformatted value or .Text to show it in the same format as in the cell
Next iCol
i = i + 1
End With
Next iListRow
End Sub


Note here is a nice guide how to work with list objects.






share|improve this answer


























  • I am getting a Could not set the List property. Invalid property value. When iCol = 10 and iListRow = 0 at the .list(i, iCol) = iListRow.Cells(1, iCol).Value using the data table shown above for some reason. I never knew you could populate a list similarly to an array though and that it starts at row 0. Thanks

    – Pherdindy
    Nov 20 '18 at 8:40













  • I'll check around on my data maybe there's some format that makes it unable to add to the list. But I think this should work

    – Pherdindy
    Nov 20 '18 at 8:52






  • 1





    Check the value of iListRow.Cells(1, iCol).Value when the error occurs. This should work. I assume there is an error in the cell. Use either .list(i, iCol) = CStr(iListRow.Cells(1, iCol).Value) or .list(i, iCol) = iListRow.Cells(1, iCol).Text (to show the value in the same format as it was shown in the cell).

    – Pᴇʜ
    Nov 20 '18 at 8:53













  • Thanks still working on finding why it's failing. I tried the other two to try convert it to string, but still the same issue. But what's weird is that it's the same text of TEST could the listbox have a limit on the number of columns? I found this there is indeed a 9 column limit mrexcel.com/forum/excel-questions/…

    – Pherdindy
    Nov 20 '18 at 9:11








  • 1





    @Pherdindy Note that you don't even need to loop to copy the filtered range. Which makes it even easier.

    – Pᴇʜ
    Nov 20 '18 at 9:25
















2














You can populate each list row and then add the columns to it:



Option Explicit

Private Sub UserForm_Initialize()
Dim tblFoilProfile As ListObject
Set tblFoilProfile = ThisWorkbook.Worksheets("Foil Profile").ListObjects("tblFoilProfile")

Dim i As Long

lbxFoilInfoDisplay.Clear

Dim iListRow As Range
For Each iListRow In tblFoilProfile.DataBodyRange.SpecialCells(xlCellTypeVisible).Rows
With Me.lbxFoilInfoDisplay
.AddItem iListRow.Cells(1, 1).Value 'add first value (column 1)

Dim iCol As Long
For iCol = 2 To iListRow.Columns.Count 'add all other columns to that row
.list(i, iCol) = iListRow.Cells(1, iCol).Value '.Value for unformatted value or .Text to show it in the same format as in the cell
Next iCol
i = i + 1
End With
Next iListRow
End Sub


Note here is a nice guide how to work with list objects.






share|improve this answer


























  • I am getting a Could not set the List property. Invalid property value. When iCol = 10 and iListRow = 0 at the .list(i, iCol) = iListRow.Cells(1, iCol).Value using the data table shown above for some reason. I never knew you could populate a list similarly to an array though and that it starts at row 0. Thanks

    – Pherdindy
    Nov 20 '18 at 8:40













  • I'll check around on my data maybe there's some format that makes it unable to add to the list. But I think this should work

    – Pherdindy
    Nov 20 '18 at 8:52






  • 1





    Check the value of iListRow.Cells(1, iCol).Value when the error occurs. This should work. I assume there is an error in the cell. Use either .list(i, iCol) = CStr(iListRow.Cells(1, iCol).Value) or .list(i, iCol) = iListRow.Cells(1, iCol).Text (to show the value in the same format as it was shown in the cell).

    – Pᴇʜ
    Nov 20 '18 at 8:53













  • Thanks still working on finding why it's failing. I tried the other two to try convert it to string, but still the same issue. But what's weird is that it's the same text of TEST could the listbox have a limit on the number of columns? I found this there is indeed a 9 column limit mrexcel.com/forum/excel-questions/…

    – Pherdindy
    Nov 20 '18 at 9:11








  • 1





    @Pherdindy Note that you don't even need to loop to copy the filtered range. Which makes it even easier.

    – Pᴇʜ
    Nov 20 '18 at 9:25














2












2








2







You can populate each list row and then add the columns to it:



Option Explicit

Private Sub UserForm_Initialize()
Dim tblFoilProfile As ListObject
Set tblFoilProfile = ThisWorkbook.Worksheets("Foil Profile").ListObjects("tblFoilProfile")

Dim i As Long

lbxFoilInfoDisplay.Clear

Dim iListRow As Range
For Each iListRow In tblFoilProfile.DataBodyRange.SpecialCells(xlCellTypeVisible).Rows
With Me.lbxFoilInfoDisplay
.AddItem iListRow.Cells(1, 1).Value 'add first value (column 1)

Dim iCol As Long
For iCol = 2 To iListRow.Columns.Count 'add all other columns to that row
.list(i, iCol) = iListRow.Cells(1, iCol).Value '.Value for unformatted value or .Text to show it in the same format as in the cell
Next iCol
i = i + 1
End With
Next iListRow
End Sub


Note here is a nice guide how to work with list objects.






share|improve this answer















You can populate each list row and then add the columns to it:



Option Explicit

Private Sub UserForm_Initialize()
Dim tblFoilProfile As ListObject
Set tblFoilProfile = ThisWorkbook.Worksheets("Foil Profile").ListObjects("tblFoilProfile")

Dim i As Long

lbxFoilInfoDisplay.Clear

Dim iListRow As Range
For Each iListRow In tblFoilProfile.DataBodyRange.SpecialCells(xlCellTypeVisible).Rows
With Me.lbxFoilInfoDisplay
.AddItem iListRow.Cells(1, 1).Value 'add first value (column 1)

Dim iCol As Long
For iCol = 2 To iListRow.Columns.Count 'add all other columns to that row
.list(i, iCol) = iListRow.Cells(1, iCol).Value '.Value for unformatted value or .Text to show it in the same format as in the cell
Next iCol
i = i + 1
End With
Next iListRow
End Sub


Note here is a nice guide how to work with list objects.







share|improve this answer














share|improve this answer



share|improve this answer








edited Nov 20 '18 at 8:58

























answered Nov 20 '18 at 8:15









PᴇʜPᴇʜ

21k42650




21k42650













  • I am getting a Could not set the List property. Invalid property value. When iCol = 10 and iListRow = 0 at the .list(i, iCol) = iListRow.Cells(1, iCol).Value using the data table shown above for some reason. I never knew you could populate a list similarly to an array though and that it starts at row 0. Thanks

    – Pherdindy
    Nov 20 '18 at 8:40













  • I'll check around on my data maybe there's some format that makes it unable to add to the list. But I think this should work

    – Pherdindy
    Nov 20 '18 at 8:52






  • 1





    Check the value of iListRow.Cells(1, iCol).Value when the error occurs. This should work. I assume there is an error in the cell. Use either .list(i, iCol) = CStr(iListRow.Cells(1, iCol).Value) or .list(i, iCol) = iListRow.Cells(1, iCol).Text (to show the value in the same format as it was shown in the cell).

    – Pᴇʜ
    Nov 20 '18 at 8:53













  • Thanks still working on finding why it's failing. I tried the other two to try convert it to string, but still the same issue. But what's weird is that it's the same text of TEST could the listbox have a limit on the number of columns? I found this there is indeed a 9 column limit mrexcel.com/forum/excel-questions/…

    – Pherdindy
    Nov 20 '18 at 9:11








  • 1





    @Pherdindy Note that you don't even need to loop to copy the filtered range. Which makes it even easier.

    – Pᴇʜ
    Nov 20 '18 at 9:25



















  • I am getting a Could not set the List property. Invalid property value. When iCol = 10 and iListRow = 0 at the .list(i, iCol) = iListRow.Cells(1, iCol).Value using the data table shown above for some reason. I never knew you could populate a list similarly to an array though and that it starts at row 0. Thanks

    – Pherdindy
    Nov 20 '18 at 8:40













  • I'll check around on my data maybe there's some format that makes it unable to add to the list. But I think this should work

    – Pherdindy
    Nov 20 '18 at 8:52






  • 1





    Check the value of iListRow.Cells(1, iCol).Value when the error occurs. This should work. I assume there is an error in the cell. Use either .list(i, iCol) = CStr(iListRow.Cells(1, iCol).Value) or .list(i, iCol) = iListRow.Cells(1, iCol).Text (to show the value in the same format as it was shown in the cell).

    – Pᴇʜ
    Nov 20 '18 at 8:53













  • Thanks still working on finding why it's failing. I tried the other two to try convert it to string, but still the same issue. But what's weird is that it's the same text of TEST could the listbox have a limit on the number of columns? I found this there is indeed a 9 column limit mrexcel.com/forum/excel-questions/…

    – Pherdindy
    Nov 20 '18 at 9:11








  • 1





    @Pherdindy Note that you don't even need to loop to copy the filtered range. Which makes it even easier.

    – Pᴇʜ
    Nov 20 '18 at 9:25

















I am getting a Could not set the List property. Invalid property value. When iCol = 10 and iListRow = 0 at the .list(i, iCol) = iListRow.Cells(1, iCol).Value using the data table shown above for some reason. I never knew you could populate a list similarly to an array though and that it starts at row 0. Thanks

– Pherdindy
Nov 20 '18 at 8:40







I am getting a Could not set the List property. Invalid property value. When iCol = 10 and iListRow = 0 at the .list(i, iCol) = iListRow.Cells(1, iCol).Value using the data table shown above for some reason. I never knew you could populate a list similarly to an array though and that it starts at row 0. Thanks

– Pherdindy
Nov 20 '18 at 8:40















I'll check around on my data maybe there's some format that makes it unable to add to the list. But I think this should work

– Pherdindy
Nov 20 '18 at 8:52





I'll check around on my data maybe there's some format that makes it unable to add to the list. But I think this should work

– Pherdindy
Nov 20 '18 at 8:52




1




1





Check the value of iListRow.Cells(1, iCol).Value when the error occurs. This should work. I assume there is an error in the cell. Use either .list(i, iCol) = CStr(iListRow.Cells(1, iCol).Value) or .list(i, iCol) = iListRow.Cells(1, iCol).Text (to show the value in the same format as it was shown in the cell).

– Pᴇʜ
Nov 20 '18 at 8:53







Check the value of iListRow.Cells(1, iCol).Value when the error occurs. This should work. I assume there is an error in the cell. Use either .list(i, iCol) = CStr(iListRow.Cells(1, iCol).Value) or .list(i, iCol) = iListRow.Cells(1, iCol).Text (to show the value in the same format as it was shown in the cell).

– Pᴇʜ
Nov 20 '18 at 8:53















Thanks still working on finding why it's failing. I tried the other two to try convert it to string, but still the same issue. But what's weird is that it's the same text of TEST could the listbox have a limit on the number of columns? I found this there is indeed a 9 column limit mrexcel.com/forum/excel-questions/…

– Pherdindy
Nov 20 '18 at 9:11







Thanks still working on finding why it's failing. I tried the other two to try convert it to string, but still the same issue. But what's weird is that it's the same text of TEST could the listbox have a limit on the number of columns? I found this there is indeed a 9 column limit mrexcel.com/forum/excel-questions/…

– Pherdindy
Nov 20 '18 at 9:11






1




1





@Pherdindy Note that you don't even need to loop to copy the filtered range. Which makes it even easier.

– Pᴇʜ
Nov 20 '18 at 9:25





@Pherdindy Note that you don't even need to loop to copy the filtered range. Which makes it even easier.

– Pᴇʜ
Nov 20 '18 at 9:25


















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53388381%2flistbox-not-showing-the-values-that-were-populated-in-it-using-listbox-list-meth%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

'app-layout' is not a known element: how to share Component with different Modules

android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

WPF add header to Image with URL pettitions [duplicate]