Oops..sorry. Below is the code, it's pretty basic. "Interface" is the first
sheet which serves as an input form. Cell E4 is linked to ComboBox3, Cell E5
is simply an input cell, and Cell E8 is linked to ComboBox5. The ComboBoxes
are placed directly over the corresponding cells, and the code is all written
using references to the cells. When you populate the combo boxes, the cells
do update (I moved one over to make sure). Everything in the workbook
functions (populating the other sheets, calculations, etc...) What is wrong
is the code clears out the cell behind the combo box, but does not update the
combo box. Is there a setting under "properties" that would fix this? Any
ideas would be great!! Thanks!!

"Kiba" wrote:

Can you post your code?

"ClintG" wrote:

Hi, I've inherited a workbook which performs multiple functions and has input
cells and combo boxes on the first sheet (the first sheet serves as an input
page). Information is entered on this input form into cells and combo boxes,
then a button is clicked to enter the info and the macro also clears out the
input cells / boxes. This used to work fine, but something has evidently
happened and now only the cells clear out. The combo boxes stay populated.
I don't see anything in the code that has changed. Any ideas or suggestions?
Thanks!!