Issue with textbox_exit event

[thorpyuk]

Hiya,

I've a userform with a textbox that allows me to pop in a comment.

I save what i write in the textbox back to my data sheet by using:

Private Sub TextBox35_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If blnHaltChange Then Exit Sub
If IsError(Application.Match(Val(TextBox1.Text), Worksheets("Project").Range("A:A"), 0)) Then Exit Sub
Sheets("Project").Range("AM" & f.Row).Value = TextBox35.Value
End Sub

However, i have a combobox that lets me select different records, and when i choose a different record, this does not trigger my exit event, and my comment is lost.


I tried putting Textbox44_Exit in my combobox change code, but it didn't like that.... has anyone any other ideas how i might force my exit event?

Thanks!

 

[RoryA]

The Exit event should fire as soon as you click on the combobox if you were in the textbox. Are you sure your blnhaltchange variable isn't set to True?
(I don't see where Textbox44 comes into it at all)

 

[thorpyuk]

Oops, yes i meant i tried Textbox35_Exit and that didn't work...

Nope, blnhaltchange is definitely set to false, but the exit event isn't firing when clicking the combobox :/

It works if i click off the textbox, or click on my exit button :/

I am setting the bln indicator to true immediately using combobox3_click.

would this fire before textbox35_exit?

Private Sub ComboBox3_Click()
If blnHaltChange Then Exit Sub

blnHaltChange = True
On Error Resume Next

 

[thorpyuk]

*hump*

 

[thorpyuk]

anyone any idea why my textbox exit event wont work? :s

 

[thorpyuk]

Still cant figure this rat out!

I've tried moving my code to the change event rather than the click event, but i'm sure that the exit event for my textbox would always go before both of those :/

Does anyone have any ideas at all? :/

 

[dialup]

hi

couldn't you use

private sub textbox35_afterupdate()

'your code here

end sub

as the event?

 

[thorpyuk]

When does afterupdate trigger?

 

[RoryA]

Have you tried putting a breakpoint on the first line of the textbox exit event just to check if it is even trying to fire?

 

[dialup]

When does afterupdate trigger?

it will trigger on leaving the textbox after a change has been made