Fill userform, combobox and frame based on data from multiple worksheets

NoSparks · #1 04-24-2018, 06:42 AM

I'm sure you'll find that interesting.

I'd suggest starting by aligning the textbox names with the associated label names.

Textbox1 with Label1 and Textbox2 with Label2 etc., not Dte08012019 with Label1 and Textbox1 with Label2.

Good luck with your project.

Divinedar · #2 04-26-2018, 10:05 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Summing data from multiple worksheets in a workbook and placing into another worksheet	safrac	Excel	17	10-04-2022 12:21 PM
Merging 2 different cells containing IF formula & change in cell values based on multiple time frame	jay_excel	Excel	0	07-29-2017 11:04 PM
Excel to Word data import based on UserForm entry	jhancock1994	Word VBA	8	05-16-2017 04:41 PM
Using combobox to pass data from an Excel spread sheet to text boxes on userform	Stewie840	Word VBA	14	12-17-2015 10:13 PM
Conditional color fill based on presence of data	avanderh	Excel	11	07-28-2011 09:10 AM