I have the above code to add a new 'consultant' to an existing list should the user wish to do so. I've tried to set the code to automatically increase the size of the RowSource currently being used in VBA (which at the moment is set as C1:C10) however it just doesn't work.
I've tried setting the RowSource manually with VBA code however it doesn't seem to work for me so I've had to use the properties window. Does anyone know a way of forcing VBA to change a value set in itself (if a new consultant was added now it should automatically change the RowSource to C1:C11, then C1:C12 for the next one etc)?
Many thanks in advance for anyones help.
~Liam
Bookmarks