xcombox

Hi - I borrowed this code from ExtendOffice. Unfortunately, it shows multiple combos when in protected mode. There are two lines to toggle on and off protection which is slow and inefficient. How can I display just one instance of the combo without having to toggle protection? Private Sub...

Hello, I am using an Autofill Code for in a a dropdown list. I have formulas in other cells that are dependent on the drop down cell entry and work when the Autofill Code and Combobox are removed. The code works fine if the entry is alphanumeric but will not work if the entry is only numeric...

I have a worksheet with the following Macro to auto complete pull-downs. Every few months I get the error "Compile Error: Method or data member not found" and have to spend time recreating the file. How can I prevent this error from happening again? Private Sub...