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:
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!![]()
Private Sub CommandButton1_Click() ActiveSheet.PageSetup.RightHeader = "&BTitle&B" & Chr(10) & TextBox1.Text & Chr(10) & TextBox2.Text & " " & ComboBox1.Text UserForm1.Hide End Sub
Cheers,
Emerson
Bookmarks