change event

I have a comboxbox on a userform. When I open the project from my computer everything opens and works as it should. If I save the file to a shared drive and open it on another computer I get an error when trying to change the date within the combobox. The error message says "Compile Error...

A user mistakenly clicks a checkbox from False to True. I want a message box to pop up saying "Are you sure?" If user responds "NO" then I want to exit out of the routine and set the checkbox back to False. But the problem is that when I do this, the event is re-fired and AddCols() procedure...

Hello, I have a worksheet that I frequently paste data into so that it can be used by another sheet in the workbook. I've inserted a procedure to change numbers stored as text into values into the worksheet object, and it works perfectly when I paste the data into the sheet. However, if I...

I want a macro to run automatically (it changes several cells' validation lists on the basis of the text in the active cell) anytime the active cell is exited and the value in the cell has changed. (I use a validataion list to fill the active cell) I have tried several versions of if statements...