Help Populating Textboxes in Userform, With Multipage Userform.

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.

Please Login or Register  to view this content.

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?