Yaneth asked 2 years ago
I am confused on the ppbr and ehp on the batch output worksheet. Am I supposed to put the $10 and 25% that are in the example for the whole columns or do I insert numbers myself? I tried to leave them blank but then I don\’t get the other outputs. If I do insert numbers for ppbr and ehp, do I code them in my sub or do I insert them directly onto the worksheet?
1 Answers
Cory Anderson answered 2 years ago
You can code them in your sub by referencing the user form. So like I directly put in $10 and 25% on the user form, but then for the batch code I referenced those cells like this:
PPBR= Sheets(“User Form”).Cells(22,3).value
(just posting this for Cindi so that it says answered)
Your Answer
You can code them in your sub by referencing the user form. So like I directly put in $10 and 25% on the user form, but then for the batch code I referenced those cells like this:
PPBR= Sheets(“User Form”).Cells(22,3).value