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.