Tony Miall
Active Member
- Joined
- Oct 16, 2007
- Messages
- 304
Hi all,
Just starting out with user forms and I would like the sheet to calculate when the user exits a combo box after entering a value and moves to the next one . I've tried a few things like
but cant get it to happen.
any help appreciated as usual
Just starting out with user forms and I would like the sheet to calculate when the user exits a combo box after entering a value and moves to the next one . I've tried a few things like
Code:
Private Sub State_AfterUpdate()
If STDORDERFORMENTRY.State.Value <> "" Then
Sheets("STD ORDER").Calculate
End If
End Sub
but cant get it to happen.
any help appreciated as usual