UserForm VLookUp

NoSparks · #9 03-04-2019, 08:02 PM

Most every Excel forum on the net has specific rules regarding cross posting.
I don't believe this forum actually has a written rule, but courtesy is always appreciated.
Have a read of this for an understanding of why it is important to let everyone know the situation:
https://www.excelguru.ca/content.php?184

As stated in post #5

Quote:

writing to the sheet can be done in a similar fashion with things inside the With-End With being swapped the other way round

Code:

If Not fndRng Is Nothing Then
    With Me
        fndRng.Offset(, 1) = .Date_TB2
        fndRng.Offset(, 2) = .Name_TB2
        fndRng.Offset(, 3) = .Area_TB2
        fndRng.Offset(, 4) = .Account_TB2
        fndRng.Offset(, 5) = .PartNum_TB2
        fndRng.Offset(, 6) = .PartName_TB2
        fndRng.Offset(, 7) = .Quantity_TB2
        fndRng.Offset(, 8) = .RequestedDate_TB2
        fndRng.Offset(, 9) = .Complete_TB2
        fndRng.Offset(, 10) = .Build_TB2
    End With
End If

As 'stuff' from a text box is text, some things, like dates, may need formatting for Excel to accept and display the way you want.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array	EcommDOC	Excel	7	01-22-2018 11:00 AM
Help with UserForm	walber	Excel Programming	3	01-30-2017 12:12 AM
Userform calls other userform, then populate worksheet	Lehoi	Excel Programming	0	02-03-2016 02:58 PM
VBA Code in a UserForm module to delete a Command Button which opens the userform	Simoninparis	Word VBA	2	09-21-2014 03:50 AM
Is it possible to take an input from a UserForm in one document to a UserForm in a do	BoringDavid	Word VBA	5	05-09-2014 09:08 AM