I am trying to achieve something which can easily be achieved with an active X combo box on Excel. I have a form control combo box, the input range is in column A. In addition to the values that the drop down box shows I also want the ability to manually put in a value that is not in the input range. I could do that using active x control combo box but need to eliminate this as some users with Mac are having problems and also ran into other issues with active x control objects on the file.
Is it possible to achieve this using form control combo box? Is there any way to manipulate this form control via VBA to do that?
Attached is my sample file illustrating what I just described above.