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.

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.

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.

So does anything get selected?

--
HTH

Bob Phillips

"ben" (remove this if mailing direct) wrote in message
...
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.

absolutely nothing gets selected. thank you but I found out i had a better
way to accomplish the desired ends, still can't highlight, but since i
couldn't get it working i just programmed something else. Thank you however
Ben
--
When you lose your mind, you free your life.


"Bob Phillips" wrote:

So does anything get selected?

--
HTH

Bob Phillips

"ben" (remove this if mailing direct) wrote in message
...
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.