Forum Discussion
Possible for UserForm to Output to Multiple Sheets?
Hello!! I'm a new user of Microsoft Excel still learning the ropes and I've got a question for you guys. I have created a Call Log for myself (I'm in sales) in which I have a UserForm where I inp...
Just use a logical VBA statement to evaluate where to put the data. ie....use criteria to pick the worksheet
If UserForm1.Textbox1.Value = "X" Then
Sheets("Sheet1").Activate
Elseif UserForm1.Textbox1.Value = "Y"
Sheets("Sheet2").Activate
Else
Sheets("Sheet3").Activate
End If
Matt,
Thank you for your response! Could you elaborate a bit more? I am still very new to Excel, UserForms, VBS, etc.
I appreciate your help!!