I have a user form with a button on it where I want the following code to run when clicked.
For some reason the code stops executing right after the worksheet activate command. It does not change the cell values nor hide the userform (it doesn't create an error either). Any ideas as to what might be causing this?
This code did work well until I made a few changes to the workbook and created some custom functions. Why would the creation of custom functions cause this to happen?
I have also discovered that this problem only affects code that references cells that utilizes a drop down list created with data validation to place an entry in a cell.
When I comment out the custom functions the code runs well.
Any idea as to what might be causing this?
George
Code:
Private Sub CommandButton1_Click()
Worksheets("Manure Source Info").Activate
[C34] = [D45]
[C35] = [D46]
[C36] = [D47]
UserForm5.Hide
End Sub
For some reason the code stops executing right after the worksheet activate command. It does not change the cell values nor hide the userform (it doesn't create an error either). Any ideas as to what might be causing this?
This code did work well until I made a few changes to the workbook and created some custom functions. Why would the creation of custom functions cause this to happen?
I have also discovered that this problem only affects code that references cells that utilizes a drop down list created with data validation to place an entry in a cell.
When I comment out the custom functions the code runs well.
Any idea as to what might be causing this?
George