Link a Formulated Cell to a Label Caption in a Userform in Real Time

Ladies and Gentlemen,
Respectfully request some assistance please. I would like to display a cell value (“F15”) into a label caption (label20) in real time, in other words not just when the userform is launched.
I can’t use UserForm_Initialize() because I’m already using it for another code in the userform. I’ve tried and got an “Ambiguous Name Detected” error. I’ve also tried to this from the worksheet as Worksheet_SelectionChange(ByVal Target As Range) but neither method works. I’ve tried several code found online including some found in here and none work. I’m losing hope, can some please out with this. The code I’m using is below. Also, I need to mention that the cell (“F15”) is populate through a formula. Thank you as always.

Please Login or Register  to view this content.

I see no reason why you can not include that code in the initialize event. Do not create a copy of the event or you will get the Ambiguous name detected. Simply add the code within the existing routine.

If the userform changes cells which causes the linked cell to update then you will need to refresh the label. This can be done by adding your code to the end of the routine that changes cells.
If the userform is modeless and the user can change cells which affect the linked cell then you will need to create an object that allows you to detect cell changes.

If you need more help post an example workbook and explain how it should be used in order to make the cell change.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

This will update label when userform is shown

Please Login or Register  to view this content.

And adding the same thing to the end of the calculation routine will refresh the label

Please Login or Register  to view this content.