Cell with Formula not Updating

[tryingmybest418]

Hi all,

I have a userform that will enter a date into E4 when I click Submit. Cell F4 has a formula to vlookup the date from E4.

F4 is not automatically updating when I click Submit. It will update if I click in E4 and press Enter.

Is there a way to ensure the formula in F4 recognizes the date and updates?

Thanks

 

[JoeMo]

Have you tried adding a line to your code to calculate the sheet or even just calculate F4? Something like:

Activesheet.Calculate

or just

Activesheet.Range("F4").Calculate

 

[tryingmybest418]

Thanks for the reply.

I tried both options, but neither seem to solve it.

 

[JoeMo]

How exactly did you introduce the options? We can only guess if you don't post your code.