Search results for query: *

I found the step that I was missing. I never changed the columncount property and didn't understand the concept of altering an array, then making the .List property equal to it. Once I performed the steps suggested by PHV above and figured out how I was going about it the wrong way, I was able...

Drag and Drop.

Just realized that I made two errors in that previous post... First, I DIMed my control twice, Second, I never specified that the checkbox is supposed to go into ListBox1.

Thanks PHV for the suggestion, but I still seem to be missing something. I have scoured the help files and the closest I can get is this: On my userform_initialize: Dim CheckBox10 As Control And in one of the private subs: Dim CheckBox10 As Control Set CheckBox10 =...

Hello, I'm making a form and have it almost complete, but I'm having trouble putting checkboxes with text and perhaps a couple other columns in a listbox. And, I'm not sure if a listbox is even the proper control to use. The data from a source will be displayed with a check box next to it so...

Thanks to both of you. I ended up writing a nested For-Next loop to solve the problem and was quite surprised at the speed. I will rewrite using each of the two methods you've shown and let you know what gives me the best results.

Probably a stupid question, but I have a list of almost 9000 non-series numbers in a column in Excel. I would like to add data on the same row as a specific number. I could scan through the whole list to find it, but I'm afraid that it will slow my application down to a crawl. Is there...