I am almost too embarrassed to ask my question. If it weren't for the fact I NEED to solve this issue I would just drop the whole thing...BUT, I need a solution. I have looked at all the posts (most anyway) relating to how one fires a macro upon a dropdown choice. Almost all refer to the change value function. I have placed a (forms) dropdown menu on sheet 1 and the list items a located on sheet 2. The cell holding the value is located on sheet 1 in cell H33. The dropdown list contains list item "Purchase", "Refinance", "Streamline". Cell H33 reflect "1" when "Purchase" is selected and "2" when "Refinance" and so on. I have a macro named Purchase which runs with no errors when tested by itself. However, when I try to tie the drop down list choice to the macro NOTHING happens. No error message box-nothing. For my life I cannot seem to get this basic function. I have tried putting the code on the sheet, in separate modules-nothing seems to be working. Can someone please show me the way on this.