Help Populating Textboxes in Userform, With Multipage Userform.

[mdmorgan24]

Hi Everyone,

First off I am new to VB for excel, most everything I need to do is just done with excel.

I am running into a problem. I am trying to create a Userform to make User input easier because my spreadsheet is so long and intensive.

I created Userform1 and My Textbox1 pulls a Report # from the Daily Mud Report Tab. I need all my textboxes to Use this number to lookup the Report # in the Mud Checks Tab Column A, then populate the other text boxes accordingly. The problem I think I am facing is that the Textbox 1 and textbox 2 are outside of the multipage control. I need these outside of the multipage control so users do not have to reenter a report number and date for all 4 of the multipage tabs. Each Multipage tab is supposed to be the same report number, but pulling data from different columns since we have 4 reports in any one day. Mud Check 2 In pulls data from "Mud Checks"range A:AL, then the next mud check 2 in further down the spreadsheet.

I thought using a controlsource property would work at first but it is only good for one cell or range. Then I tried writing the code out in VB

Similiar to this. But it doesn't pull into the multipage form.

Me.TextBox4.ControlSource = Application.VLookup(Me.TextBox1, Sheets("Mud Checks").Range("A:AL"), 4, False)

What would be the best way to have these pull from a VLookup and still be able to update the corresponding cells in the worksheet on text change or button click?