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:
There should be 11 columns populating the listbox based on the excel table below:
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:
excel vba excel-vba listbox
asked Nov 20 '18 at 7:47
PherdindyPherdindy
84218
add a comment |
1
After running the Userform_Initialize() event, there would be nothing populated in the listbox as shown below:
There should be 11 columns populating the listbox based on the excel table below:
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:
excel vba excel-vba listbox
asked Nov 20 '18 at 7:47
PherdindyPherdindy
84218
@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 nestedfor-nextloop that loops through the row and columns so each cell in the table would be assigned to one cell in the array instead? Will theListbox.listmethod work from there if I assign to itMyArr(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 theAfter_Update()events of each combo box but I don't know how to populate the list using VBA becauseRowSourcemethod uses an excel string formula as an argument which will not work because i'm usingAutofilter. I have a work around of having a helper worksheet usePasteSpecialthen 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
add a comment |
1
1
1
1
After running the Userform_Initialize() event, there would be nothing populated in the listbox as shown below:
There should be 11 columns populating the listbox based on the excel table below:
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:
excel vba excel-vba listbox
asked Nov 20 '18 at 7:47
PherdindyPherdindy
84218
After running the Userform_Initialize() event, there would be nothing populated in the listbox as shown below:
There should be 11 columns populating the listbox based on the excel table below:
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:
excel vba excel-vba listbox
excel vba excel-vba listbox
asked Nov 20 '18 at 7:47
PherdindyPherdindy
84218
asked Nov 20 '18 at 7:47
PherdindyPherdindy
84218
asked Nov 20 '18 at 7:47
PherdindyPherdindy
84218
asked Nov 20 '18 at 7:47
PherdindyPherdindy
84218
asked Nov 20 '18 at 7:47
PherdindyPherdindy
84218
84218
@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 nestedfor-nextloop that loops through the row and columns so each cell in the table would be assigned to one cell in the array instead? Will theListbox.listmethod work from there if I assign to itMyArr(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 theAfter_Update()events of each combo box but I don't know how to populate the list using VBA becauseRowSourcemethod uses an excel string formula as an argument which will not work because i'm usingAutofilter. I have a work around of having a helper worksheet usePasteSpecialthen 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
add a comment |
@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 nestedfor-nextloop that loops through the row and columns so each cell in the table would be assigned to one cell in the array instead? Will theListbox.listmethod work from there if I assign to itMyArr(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 theAfter_Update()events of each combo box but I don't know how to populate the list using VBA becauseRowSourcemethod uses an excel string formula as an argument which will not work because i'm usingAutofilter. I have a work around of having a helper worksheet usePasteSpecialthen 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
add a comment |
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.
answered Nov 20 '18 at 8:15
PᴇʜPᴇʜ
23.1k62950
I am getting aCould not set the List property. Invalid property value.WheniCol = 10andiListRow = 0at the.list(i, iCol) = iListRow.Cells(1, iCol).Valueusing 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 ofiListRow.Cells(1, iCol).Valuewhen 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 ofTESTcould 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
|
show 3 more comments
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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.
answered Nov 20 '18 at 8:15
PᴇʜPᴇʜ
23.1k62950
I am getting aCould not set the List property. Invalid property value.WheniCol = 10andiListRow = 0at the.list(i, iCol) = iListRow.Cells(1, iCol).Valueusing 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 ofiListRow.Cells(1, iCol).Valuewhen 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 ofTESTcould 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
|
show 3 more comments
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.
answered Nov 20 '18 at 8:15
PᴇʜPᴇʜ
23.1k62950
I am getting aCould not set the List property. Invalid property value.WheniCol = 10andiListRow = 0at the.list(i, iCol) = iListRow.Cells(1, iCol).Valueusing 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 ofiListRow.Cells(1, iCol).Valuewhen 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 ofTESTcould 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
|
show 3 more comments
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.
answered Nov 20 '18 at 8:15
PᴇʜPᴇʜ
23.1k62950
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.
answered Nov 20 '18 at 8:15
PᴇʜPᴇʜ
23.1k62950
edited Nov 20 '18 at 8:58
answered Nov 20 '18 at 8:15
PᴇʜPᴇʜ
23.1k62950
answered Nov 20 '18 at 8:15
PᴇʜPᴇʜ
23.1k62950
answered Nov 20 '18 at 8:15
PᴇʜPᴇʜ
23.1k62950
23.1k62950
I am getting aCould not set the List property. Invalid property value.WheniCol = 10andiListRow = 0at the.list(i, iCol) = iListRow.Cells(1, iCol).Valueusing 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 ofiListRow.Cells(1, iCol).Valuewhen 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 ofTESTcould 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
|
show 3 more comments
I am getting aCould not set the List property. Invalid property value.WheniCol = 10andiListRow = 0at the.list(i, iCol) = iListRow.Cells(1, iCol).Valueusing 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 ofiListRow.Cells(1, iCol).Valuewhen 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 ofTESTcould 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
|
show 3 more comments
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
@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-nextloop that loops through the row and columns so each cell in the table would be assigned to one cell in the array instead? Will theListbox.listmethod work from there if I assign to itMyArr(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 becauseRowSourcemethod uses an excel string formula as an argument which will not work because i'm usingAutofilter. I have a work around of having a helper worksheet usePasteSpecialthen 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