Code to input text requires double click to work

[Trixsix]

I have a piece of code that is set to input "yes" or "no" into a specific cell dependant on user input on a different sheet. I can only get the "yes" or "no" to appear when I double click the cell and press enter. Is there anyway to refresh or double click the cell within VBA? I have checked the workbook calculation options are set to automatic.

 

[Joe4]

Welcome to the Board!

Please post your code so we can see what it is to do.

 

[Trixsix]

Here is the code. I have not really worked with VBA before and some of this was done by a developer who has since been moved to a different project so please bear with me. Thank you.

'Scheme selection to allow correct fields to be shown based on selection
Private Sub Worksheet_Change(ByVal Target As Range)
' On Error GoTo ErrorHandling
Set App = Application
App.ScreenUpdating = False
If blSelCheck = True _
Then Exit Sub _
Else blSelCheck = True
CalcComPI.Unprotect Password:=strPass
'Commutation Required?' Selection
If Sheet3.Range("P66").Value = "Yes" _
Then CalcComPI.Range("E20") = "Yes" _
Else CalcComPI.Range("E20") = "No"
If CalcComPI.Range(strAppCommSel).Value = "Yes" _
Then CalcComPI.Range(strAppCommRows).Rows().Hidden = False _
Else CalcComPI.Range(strAppCommRows).Rows().Hidden = True
blSelCheck = False
CalcComPI.Protect Password:=strPass
App.ScreenUpdating = True
Exit Sub
ErrorHandling:
MsgBox Err.Number & " " & Err.Description, vbOKOnly + vbCritical, "Error: " & Err.Number
blSelCheck = False
Application.DisplayAlerts = True
Application.DisplayFormulaBar = True
Application.ScreenUpdating = True
End Sub

 

[Joe4]

That code is set to run whenever a cell is manually updated (using "Enter" is one way of doing that).
Typically, the way you want these to work, is that you want your Worksheet_Change code associated to the sheet and the cells that you are updating that is supposed to trigger the whole process (not necessarily on the sheet that you want the updates/changes to happen on).

 

[Trixsix]

That code is set to run whenever a cell is manually updated (using "Enter" is one way of doing that).
Typically, the way you want these to work, is that you want your Worksheet_Change code associated to the sheet and the cells that you are updating that is supposed to trigger the whole process (not necessarily on the sheet that you want the updates/changes to happen on).

It worked a treat. Thank you!

 

[Joe4]

You are welcome!