View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 399
Default UserForm Question

TextBoxes have a Change event. You might be able to use this to set
txtBox2.Text = txtBox1.Text, etc.

HTH
Ed

"Sharon" wrote in message
...
Hello
I have a created a userform and would like the values in txtBox3-txtBox10

to
default to the value in txtBox1 once it is entered. So if I enter 100 in
txtBox1 and then go to txtBox2 the values in 3-7 will be 100 also. I am

new
to user forms and I dont know how to do this. All help would be greatly
appreciated!
Thanks in advance
Sharon