Link to home
Start Free TrialLog in
Avatar of Paul Clayton
Paul ClaytonFlag for Thailand

asked on

Out of stack space (Error 28)

Attempting to modify VBA to suit my Userform template in the attached file for column references but getting Out of stack space (Error 28) and Excel crashes.

Any assistance as to why this is happening would be greatly appreciated.

Paul
Test_Userform7.xlsm
Avatar of Martin Liss
Martin Liss
Flag of United States of America image
What action do you take that results in the error? Is it associated with clicking one of the buttons for example?
Avatar of Paul Clayton
Paul Clayton
Flag of Thailand image

ASKER

The run error occurs and thereafter Excel shuts down when I try to change the VBA code to reflect the worksheet column that I want as the txt box value on the Userform, i.e., as below from 6 to 12
        .txtPMthRev = Format(ws.Cells(lRw, 6), "#,##0.00")

Open in new window

to
        .txtPMthRev = Format(ws.Cells(lRw, 12), "#,##0.00")

Open in new window


Paul
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Paul Clayton
Paul Clayton
Flag of Thailand image

ASKER

Thanks!
Avatar of Martin Liss
Martin Liss
Flag of United States of America image
You're welcome and I'm glad I was able to help.

If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2015