Once I create a sheet I want an overview sheet pull specific values from the newly created sheet. I would like to be able to use the textbox values to be inserted into the formula but the code that I have does not work. ANy suggestions or do I have some misplaced punctuation?
Thanks in advance!
Code:
Range("C1").Formula = "='UserForm.TextBox1.value & "" "" & UserForm.TextBox2.value'!L5"
Thanks in advance!