Force Sheet Update

[dcoledc]

NOt quite sure how to ask what I am asking but here it goes. I have a DTPicker on my sheet that when changed updates a cell, let's call it "Date Cell". I am finding that if I enter information into another cell, not Date Cell, and then DO NOT hit enter or tab or whatever and select and change the DTPicker, it does not update Date Cell.

If I enter info into a cell and then hit enter then select the DTPicker and change, it will update Date Cell.

I am not sure I am using the correct verbage here, but how do I force a sheet recalculation when the DTPicker is selected?

I guess because I never actually leave the cell, Excel thinks I am not done entering information.

Hope all that made sense.

 

[RSXchin]

Put this into the "ThisWorkbook" module

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    application.enableevents = false
    '' change the datecell here
    application.enableevents = true
End Sub

 

[dcoledc]

That seems to work. Just to improve my VBA knowledge, why does it work? Is it because I am not allowing anything to happen until something else is selected?

 

[RSXchin]

You need to lookup "Events" for VBA. They're super useful when you get the hang of it.