All fields on my userform reference cells on a worksheet. When the form displays for the first time, the fields show the appropriate values for those cells.
But when the user clicks the spinbutton up or down on the form, the contents of the cells change, but NOT the fields themselves.
The only thing that does update is a ListBox that references a range on the same worksheet as the other fields.
What am I missing, please?
But when the user clicks the spinbutton up or down on the form, the contents of the cells change, but NOT the fields themselves.
The only thing that does update is a ListBox that references a range on the same worksheet as the other fields.
What am I missing, please?
Code:
Private Sub SpinButton1_SpinUp()
Worksheets("GhostData").Range("CK6").Value = Worksheets("GhostData").Range("CK6").Value + 1
End Sub
Private Sub SpinButton1_SpinDown()
Worksheets("GhostData").Range("CK6").Value = Worksheets("GhostData").Range("CK6").Value - 1
End Sub
Private Sub UserForm_Initialize()
'Enters the project ID of the active cell on Periscope
Worksheets("GhostData").Range("CK5") = Worksheets("Periscope").Cells(ActiveCell.Row, 76).Value
'Enters the row number of where the project ID is located on PivotData
Worksheets("GhostData").Range("CK6") = Worksheets("Periscope").Cells(ActiveCell.Row, 78).Value
ProjectIDField.Text = Worksheets("GhostData").Range("CK10")
ProjectNameField2.Text = Worksheets("GhostData").Range("CK11")
PortfolioField.Text = Worksheets("GhostData").Range("CK12")
End Sub