Forum Discussion

bengriffin4316's avatar
bengriffin4316
Copper Contributor
Apr 24, 2018

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...
Macros & VBA
Need Help
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
Apr 27, 2018

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

 

  • bengriffin4316's avatar
    bengriffin4316
    Copper Contributor
    May 09, 2018

    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!!

Resources