I have a code that works...but I want it to update while the userform is open and numbers can be changed...hit commandbutton and graphs in excel modified. I don't want to close the GUI everytime for it to update...I want it to by dynamic
Here is the code.
Sub CommandButton1_Click()
ActiveWorkbook.Sheets("18XYPlots").Activate
ActiveWorkbook.ActiveSheet.Range("S3:S12").ClearContents
ActiveWorkbook.ActiveSheet.Range("HE16:HE25").Copy
ActiveWorkbook.ActiveSheet.Range("S3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Transpose:=False
Call Update_Plots_Click
I've tried several things but no success
Thanks
Here is the code.
Sub CommandButton1_Click()
ActiveWorkbook.Sheets("18XYPlots").Activate
ActiveWorkbook.ActiveSheet.Range("S3:S12").ClearContents
ActiveWorkbook.ActiveSheet.Range("HE16:HE25").Copy
ActiveWorkbook.ActiveSheet.Range("S3").Select
Selection.PasteSpecial Paste:=xlPasteValues, Transpose:=False
Call Update_Plots_Click
I've tried several things but no success
Thanks