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)
Bookmarks