it loops through the other textboxes adds their values together, then
subracts that amount from a given total. THen plugs that amount into the text
box that was just clicked. The looping does not in anyway setfocus or select
the textboxes being read.
--
When you lose your mind, you free your life.


"Bob Phillips" wrote:

Works in my limited test. What does
'Change text then....
do?

--
HTH

Bob Phillips

"ben" (remove this if mailing direct) wrote in message
...
I have a userform with four text boxes. When a user activates the Enter
event
for any text box my code places a certain value in that box. That part
works
fine, however I want it to also select the text once it is entered
programmatically. THAT part does not work, no matter what I have seemed to
try.

Private Sub py4_Enter()
'Change text then....
with py4
.selstart = 0
.sellength = len(.text)
.setfocus
end with
end sub


even moving the setfocus or REmoving it helped none. Am I missing
something
simple here?


--
When you lose your mind, you free your life.