I have a userform which has a number of lines like the ones below. Currently
these values are placed on the worksheet after I click a commandbutton
(finished). What I would like is for the data to be placed on the worksheet
as I move from one textbox to the next. Is this possible?


rng(1, 47).Value = TextBox1.Text
rng(1, 48).Value = TextBox2.Text
rng(1, 53).Value = TextBox4.Text
rng(1, 54).Value = TextBox5.Text
rng(1, 71).Value = TextBox7.Text
rng(1, 59).Value = TextBox8.Text
rng(1, 60).Value = TextBox9.Text