Creating a drop-down that allows for user inputs(using macros on Excel 2007)

[sbrij91]

Hi all,

I am new to coding on excel using VB. I have created a drop-down macro by referring to many codes available online. However, my user may want to put a choice outside the options provided in the drop down. Any idea how to allow for user input?

Would really appreciate some help.

 

[Warship]

use an ActiveX ComboBox instead