Add Formula To Label Control on UserForm
Posted on 2014-02-02
I have a UserForm, that will eventually become a "popup" window that is splashed on the screen when the user opens the Excel Workbook.
I have added a "Label" control onto my UserForm, and I would like it to display the result of this formula:
="Version - "&LOOKUP(90000000000,'Change Log'!A:A)&" (Jay Burke)"
I tried adding the formula right into the Label control, and it just shows the formula itself - not the result. So either, I need to do something else? Or it's just not something that is supported?
Thank you in advance for your help!