Hi
I have a userform (several actually) based on a range of data, which allows the user to edit/add lines.
To make it easier, several fields (Title, location etc.) are combo-boxes, so that if the value exists they don't have to type it.
Obviously, it would be easier if the values were sorted. Rather than writing the same sort routine many times, is there a way of calling a sort routine from the userform_initialize procedure, but just passing into it the combobox and columns or range required?
I have a routine that inserts a value to the right place in a listbox, can you do the same thing with a combobox?
Thanks
Chris
I have a userform (several actually) based on a range of data, which allows the user to edit/add lines.
To make it easier, several fields (Title, location etc.) are combo-boxes, so that if the value exists they don't have to type it.
Obviously, it would be easier if the values were sorted. Rather than writing the same sort routine many times, is there a way of calling a sort routine from the userform_initialize procedure, but just passing into it the combobox and columns or range required?
I have a routine that inserts a value to the right place in a listbox, can you do the same thing with a combobox?
Thanks
Chris
