vba-batch-output

Questions Archivevba-batch-output
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?

cindi replied 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

enlibrari replied 2 days ago

Our company has gained immense accolades in the field of offering Heparin Sodium Injections to the clients generic azithromycin price Now, sleep is elusive

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

18 + 3 =

css.php