Looking for some help on setting global variables when a workbook is opened. I have a set of configurations I would like to read in from a worksheet when the workbook is opened and set them as global variables. In Module1 I have a variable declared as Global. Then, in ThisWorkbook in the Workbook_Open function I attempt to read in the correct cell from the worksheet named "Configs". However, it always reads in as zero. If I hardcode the value, it sets the global var correctly, but when I try to read it from the worksheet it appears as if the worksheet data hasn't loaded in yet and it gets set to zero.
Any thoughts on what I'm doing wrong?
Thanks in advance!
Any thoughts on what I'm doing wrong?
Thanks in advance!