I previously had this WB working and now it is broke. Not sure what I did, but userform9.label3 does not change to the activecell when selected in the worksheet. Would anyone have any thoughts on why this would occur? The msgbox shows the correct entry in the WS selection change event but a similar box shows blank in the WS calculation event.
Another note is that the userform updates correctly after making a 2nd selection on the WS. I need it to be immediate.
Another note is that the userform updates correctly after making a 2nd selection on the WS. I need it to be immediate.
VBA Code:
Private Sub Worksheet_Calculate()
UserForm9.Label3.Caption = Sheets("QB").Range("b522").Value
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set rng = ActiveCell
MsgBox rng
Sheets("qb").Range("b522") = rng
Last edited: