Ok I can't seem to get my textboxes to fill in with the information from each of the worksheets. HELP!!!!
HTML Code:
Private Sub cboFYList_Change()
Dim i As Long, LastRow As Long
Worksheets(“ShtFY2019”).Select
LastRow = Worksheets(“FY2019”).Range(“C” & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
If Worksheets(“FY2019”).Cells(i, “A”).Value = (Me.cboFYList) Or _
Worksheets(“FY2019”).Cells(i, “A”).Value = Val(Me.cboFYList) Then
Me.txtl0119 = Worksheets(“FY2019”).Cells(i, “C”).Value
Me.txtl0219 = Worksheets(“FY2019”).Cells(i, “D”).Value
End If
Next
End Sub
I have tried every code I know and this was the last one I tried. I don't know if it's because of the frame I can't get them to fill in and can't see where I'm going wrong.
I need to now get the textboxes populated with the information from each worksheet. If you look at the userform above there is 5 frames and each frame is a fiscal year etc., FY2019, FY2020,...
I need to be able to fill each frame from each worksheeet and if edited to be writable back to each worksheet updated.
Also I need that if info need to be added to be added before each total line under the category of INT'L, INT'L GOV and US GOV. Is this possible?
PLEASE HELP! Thank you in advance.