I put an ActiveX listbox on sheet 1. I would like to put the VBA code for the listbox click event in a module, not in the code sheet for that worksheet.
How do I re-name the click event sub ? How do I specify that the code is in a module ? If I use a Form listbox instead of an ActiveX listbox, can I write click-event code?
Thanks in advance for any advice.