View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Select Text in TextBox

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.