I see your point regarding the fact that the formating is again updating the
txtbox BUT...all the other "_AfterUpdate" routines in the Userform use the
identical format line (tho txtbox name specific) and they don't appear to
have any problem. Regarding the 2nd time the routine runs, it clears the
value (maybe because it's already formatted) and finishes with a setfocus
somewhere else then the checkbox that's specified.


"Bob Bridges" wrote:

I could be wrong, but I think you're missing this only because
it's so obvious. The routine runs whenever txtCoffeeSubCoin is
updated, and the routine updates txtCoffeeSubCoin; so when it
sets the focus somewhere else Excel figures txtCoffeeSubCoin
is now officially updated and starts the txtCoffeeSubCoin_AfterUpdate
routine. Don't you think?

--- "John G." wrote:
Private Sub txtCoffeeSubCoin_AfterUpdate()
txtCoffeeSubCoin.Value = "<something, anything"
.
.
.
CBBingoSub.SetFocus 'sets the focus to a checkbox
End Sub

My problem is with the SetFocus line. As mentioned, the other similar
routines seem to handle the setfocus OK, tho they are setting focus on the
next txtbox in order, but when the line in question is executed, the program
jumps back to the beginning of the subroutine and reruns itself....