Setting a macro for a text box

[Josiah]

I want to setup a macro which will cause anything I type in a particular text box to be duplicated automatically to a set of merged cells (in the same format as the text box - IE: returns and spacing)

What's the best way to do this?

[Josiah]

I guess I've just blown you all away with this question, huh?

:lol

[Josiah]

C'mon guys! At least tell me what I'm asking for is impossible so I'll quit coming back here to see if anyone responded...

[Keyur]

Try this

Private Sub TextBox1_Change()
Range("A1").Value = Me.TextBox1.Text
Range("A2").Value = Me.TextBox1.Text
Range("A3").Value = Me.TextBox1.Text
Range("A4").Value = Me.TextBox1.Text
End Sub

my first 4 cells in each row were merged. u only need to refer to the first one. But this does leaves you with some rectangular box when you press Ctrl+Return in the text box (this gives you mutiple lines in a text box). This is atleast a start I guess.

Keyur

[Josiah]

Thanks! I'll try it out!