Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Stepping thru the Below code goes OK EXCEPT after running
Set rngordDate = .Find(SearchOrderDate, LookIn:=xlFormulas) ' 8 lines from bottom rngordDate = Nothing <<< so it's no wonder I get R/T error 91 on next line; Can someone assist me? TIA, Private Sub CommandButton1_Click() Dim dtOrder As Range Dim intOrder As Range Dim billAmt As Double Dim ws As Worksheet Dim searchOrder Dim rngorder As Range Dim rngordDate As Range Set ws = Sheets("Sheet2") Set dtOrder = ws.Range("C4:I4") Set intOrder = ws.Range("B5:B14") searchOrder = Me.TextBox1.Value billAmt = Me.TextBox3.Value With intOrder Set rngorder = .Find(searchOrder) If Not rngorder Is Nothing Then SearchOrderDate = Me.TextBox2.Value SearchOrderDate = DateValue(SearchOrderDate) With dtOrder Set rngordDate = .Find(SearchOrderDate, LookIn:=xlFormulas) rngordDate.Offset(rngorder.Row - 4, 0).Value = billAmt End With Else MsgBox "Order not found, Try Again", vbInformation End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Userform Code | Excel Programming | |||
Have userform & reams of code! | Excel Programming | |||
UserForm code help needed. | Excel Programming | |||
UserForm code help needed. | Excel Programming | |||
VBA code for Userform | Excel Programming |