How to populate a merged cell from a form in excel

[SoConfused]

Hi there,

I'm pretty new at this all but I've asked my office guru's and they couldn't help either.

I've created a cost estimate template in excel with a form people can fill out for standard info (date, project #, project description etc.). I have it set up that the form populates all the cells no problem except when it comes to merged cells.

As soon as I try to populate a merged cell I get an error with the "Selection.Characters.Text" portion. (but again, it works fine on non-merged cells)

is there any other code I could use? txtTitle is the name of the box on the form that needs to populate cell E8 (merged E8 & F8)

Private Sub txtTitle_Change()
ActiveSheet.Range("E8").Select
Selection.Characters.Text = txtTitle
With Selection.Characters(Start:=1, Length:=90).Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 20
End With
Range("A15").Select


End Sub

Thank you so much for any help you can offer. (and if you could try to dumb down your answer it would be much appreciated ;0)

[SoConfused]

I should also say I've tried
ActiveSheet.Cells("E8").Select
ActiveSheet.Cells(8,5).Select

and it always has an issue with the "Selection.Characters.Text" line

Thank you again.