question

Hi,

You will need to unlock the macro and show us the debug for anyone to figure out what is happening.

 Dim GrpSizeTemp As Integer
 Dim CurrTierTemp As Integer
 Dim RenTierTemp As Integer
 Dim CommTemp As Integer
 Dim MOPAdjTemp As Integer
 Dim RMMTemp As Integer
   
 Dim ActDialog As String
 Dim newTextTemp As String
 Dim NtwkSelectTemp As String
 Dim noCancel As Boolean
   
 Application.Calculation = xlCalculationAutomatic
   
       
 ActDialog = "Dialog1"
 noCancel = DialogSheets(ActDialog).Show  'shows dialog box
   
 If noCancel = False Then Exit Sub
   
 'If the user has selected a trivial MOP Adjustment Factor, this will ask the user if they're sure
 If DialogSheets(ActDialog).DropDowns("cbxMOPAdj").Value = 1 And CInt(DialogSheets("Dialog1").EditBoxes("ebxEligCT").Text) > 19 Then
     Dim Response As VbMsgBoxResult
     Response = MsgBox("You have selected a MOP Adjustment Factor of 1.000.  Are you sure this is what you want?", vbQuestion + vbYesNo)
       
     If Response = vbNo Then
         GoTo Start:
     End If

 The cursor is going to the 

​[
noCancel = DialogSheets(ActDialog).Show 'shows dialog box

 it's the "shows dialog box" that is causing the problem.  I just haven't had time to look into the updates to see how we need to update that section. 

Any help would be great
Thank you

I would try to find the userform name and just do userform.show

You can find the userform names on the project window under forms.

I'll let them know and have them try that and see.

Thank you

76840-excel-maco-issue.pdf

This is the information they believe you wanted.

Thank you again.