chocho
01-14-2013, 11:14 PM
Hi,
I'm looking to populate a listbox. In another form, I have set a range of a full row, and this is set as APublicVariable. I am looking to find the value of only the cells with content in that range. Example (All in row 1): cell 1= blank, cell 2=data, cell 3=data, cell 4= blank. I do not know where the data begins or ends, only that it is in row 1. This is what I started at but its not working:
Listbox.List = ThisWorkbook.APublicVariable.UsedRange.Value
As well, when I use this to populate the list on userform initialization, I get an error in the previous userform that directs to this userform. Thanks for your help!
I'm looking to populate a listbox. In another form, I have set a range of a full row, and this is set as APublicVariable. I am looking to find the value of only the cells with content in that range. Example (All in row 1): cell 1= blank, cell 2=data, cell 3=data, cell 4= blank. I do not know where the data begins or ends, only that it is in row 1. This is what I started at but its not working:
Listbox.List = ThisWorkbook.APublicVariable.UsedRange.Value
As well, when I use this to populate the list on userform initialization, I get an error in the previous userform that directs to this userform. Thanks for your help!