VBA Yes/no msg box will only do the yes option

[JustHooch]

Ok this is probably a simple fix but I just can't see it. I have a Yes/No msg box with the below code. The problem is if you click Yes OR No it follows the No instructions.

Can someone please help me figure out what is wrong?

Private Sub CommandButtonContinue_Click()


Msg = "Scope Estimation must be completed before opening JIRA tickets. Have you already completed Scope Estimation?"
Ans = MsgBox(Msg, vbYesNo)
 
If Answer = vbNo Then[INDENT]Load UserFormScopeBOLT
UserFormJIRALodging.Hide
UserFormScopeBOLT.Show[/INDENT]
Else[INDENT]Load UserFormJIRABOLT
UserFormJIRALodging.Hide
UserFormJIRABOLT.Show[/INDENT]
End If
 
End Sub

 

[Joe4]

You are calling your variable "Ans", but then you are trying to reference "Answer" in your script.

If you use "Option Explicit" at the top of your code, it enforces you to declare all variables, and will catch errors like this.
See: https://www.excel-easy.com/vba/examples/option-explicit.html

 

[JustHooch]

Thank you. I knew that it would be something simple.