Hello,
So I 'm not sure if this is possible. I am trying to pulling data from two separate text boxes and have them italicized and placed into the header of my sheet. My code is as follows:
Private Sub CommandButton1_Click()
ActiveSheet.PageSetup.RightHeader = "&BTitle&B" & Chr(10) & TextBox1.Text & Chr(10) & TextBox2.Text & " " & ComboBox1.Text
UserForm1.Hide
End Sub
I have noticed that the basic &I command doesn't work on the textbox commands. I was thinking about italizing the entire header, however, I need the "Title" to remain bold and uninitialized. Thanks for your help!
Cheers,
Emerson
Bookmarks