I have an extensive macro (below as an example of where I would like to pause the macro) but I need to in various araes to pause the macro for the user to fill in the displayed blank feilds and then proceed. I created a userform (click command listed). I will need to do this 5 times throughout the macro.
Private Sub CommandButton1_Click()
Range("YEWIP_Data").AutoFilter Field:=12, Criteria1:="="
Range("L7", Cells(YEWIPR1, "L")).SpecialCells(xlCellTypeVisible). _
FormulaR1C1 = "=IFError(Vlookup(RC1,WMS_Lookup,6,false),"""")"