Hi, I'm creating an application that would allow me to calculate vapour pressures of at least 400 different chemicals with a user form.
To achieve that, I would need to pre-assign 3 different constants to each chemical (a, b, and c). So that when I select chemical X and provide other relevant inputs like temperature, it would be able to extract those values from a different workbook to perform the calculation.
Hence, I would like to know if there is a better way to do that instead of manually assigning each of them with pre-assigned values.
Thank you for your help.
Bookmarks