I am getting an Error 28 Stack Space error.
Here is my code. The last part of the code "Decide which form to open" is where the error occurs. The file is set up as a survey and it walks them through questions pulling up userforms. This error happens at various times.
Sub NextQ()
'
'
'Returns to last completed question
Sheets("Emp Sat Sur").Activate
Sheets("Emp Sat Sur").Range("L" & Cells.Rows.Count).End(xlUp).Activate
If ActiveCell.Offset(1, -4) <> "" Then
ActiveCell.Offset(1, -4).Activate
Else
Close_usfs.Close_usfs
usfFinished.Show
End If
'closes any open forms
Close_usfs.Close_usfs
'Decides which form to open
If ActiveCell.Offset(0, -5).Value = "C" Then usfCTemp.Show
If ActiveCell.Offset(0, -5).Value = "M" Then usfMisQ.Show
If ActiveCell.Offset(0, -5).Value = "Q" Then usfQTemp.Show
If ActiveCell.Offset(0, -5).Value = "S" Then usfSel.Show
End Sub
Bookmarks