I'm no Excel guru folks, but this issue I've searched for quite a bit and I'm not sure if this is a typical MS issue or not. There is some VBA here too. I am creating a very simple UF interface, and here is the code I have to throw data to a list box:
this works fine and I'm sure there are other ways to do this same thing. However, my question is about the ROWSOURCE, COLUMN WIDTHS and COLUMN HEADS properties . They seem to be very finicky and unreliable, which is something I've noticed with MS's office products. I am simply trying to throw sheet data into the column heads, then add items one by one, as indicated by the code. Most of it works fine. But I'd like to set the properties manually so I don't have to write lines of code. In this day in age, the writing of code is being minimized so much, I assume I can do that too in this instance. Can anyone assist here? I've gotten numerous errors, such as "invalid rowsource property" when typing in ""Sheet1!A1:L1"" into the properties argument. Google says this is fine. thanks.
Adam
Bookmarks