Hi Folks, my first time asking for help here. I'm a newbie trying to learn some tricks.
I created 2 combo box to deal with 2 different dropdown lists. I then create an automation to call the combobox with doubleclick on the cells where the dropdown should be.
If I doubleclick in Column 'P' (16) it calls the combo box "CostCentreCombo". If I doubleclick on the column 'Q' (17) it calls the combobox "GLCodesCombo".
It's almost everything good but one problem. I notice that after I call one of the combobox, use the dropdown to select a value then I get out of it just clicking in any other cell, I can't do it again on the next cell immediately. if I double click on another cell, the combobox will appear but the dropbox will not. If I simply click again on the same combobox that worked and don't select anything from the dropdown, then I can go to the second combobox. It's just a weird thing that may be happening when I LoseFocus from the object, but I don't know how to handle it. The whole code is provided below. I also include the excel file. Just go on 'Invoice' tab and double click on either collumns P or Q. Any thoughts?
Bookmarks