I created a userform with a two command buttons (Generate PT's and Close) when Generate PT's is clicked it generates 16 PT's from one source worksheet. Within each PT, cell range J4:L4 must be one color (Orange) and range M4:X4 must be a different color (Purple) to show the difference between Actuals and Forecasted data. The VBA code I wrote works for PT's 1 thru 15 with no problem. The cells even change color on PT #16, until the userform is unloaded.
Once I unload the userform (unload userform1) range J4:M4 reverts back to the original PT color scheme and range N4:X4 stays in the color I selected (Purple). The color change is the last operation before End Sub.
can't figure out why range J4:M4 reverts back after unloading the userform...
Any help is much appreciated.
Once I unload the userform (unload userform1) range J4:M4 reverts back to the original PT color scheme and range N4:X4 stays in the color I selected (Purple). The color change is the last operation before End Sub.
can't figure out why range J4:M4 reverts back after unloading the userform...
Any help is much appreciated.
