View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Knutson Mark Knutson is offline
external usenet poster
 
Posts: 1
Default UserForm Control Question

I have fifteen text boxes in my userform. They have a default value of
zero. When my form loads, the first text box has the focus. I want to
highlight or select the zero so when I enter a number into the text box
it will overwrite the zero rather then put the number after the zero. I
can't figure out the code I need to highlight the zero.

The following text boxes highlight the zero automatically when I press
enter in the previous text boxes. So I just need to be able select the
first text boxes zero. Any help will be appreciated. Thanks in advance.
By the way I have excel 2003. Thanks, Mark