Dynamically Setting Label Control Captions using Excel VBA

How to copy label's caption to a cell in excel???

Great! Well done. Tks a lot for sharing your knowledge.

Sample
I have a userform with 40 labels and 40 textboxes. I'm trying to write a code that can compare/match each label caption to a range of cells and if a match is found, set the textbox value equal to an adjacent cell.....
How can I accomplish this?

Hi Dr Grande, I have an excel template workbook that I have created with a worksheet for data entry followed by several worksheets which display the data in different charts. My question is, when I print the charts I have a date range that I input into the header to show users of my charts the time period that data is from, is there any way to have these headers auto update without me having to update each one (about 20 different charts). The date range remains in each chart when it is selected to print, but it is the last date range from when the template was saved. Thank you for all the videos you provide, many of the help me revise for my finance exams.