akaj321akaj
New Member
- Joined
- May 23, 2011
- Messages
- 11
ok so what i have so far is
it will select the first "price" cell and enter the desired price into it,
but the problem im having is whenever i already have a price in there i want it to add another price into the next empty cell to the right.
is there anyway i can do this? any help is appreciated
additional info
the data im trying to put in starts at the fifth column
Code:
Private Sub cmdSave_Click()
Dim rFind As Range
With Sheets("ItemCosts").Columns(1)
Set rFind = .Find(What:=Me.cboItem.Value, LookAt:=xlWhole, MatchCase:=False, SearchFormat:=False)
If Not rFind Is Nothing Then
rFind.offset(, 4) = Me.txtCost.Value
End If
End With
Me.txtCost.Value = ""
End Sub
but the problem im having is whenever i already have a price in there i want it to add another price into the next empty cell to the right.
is there anyway i can do this? any help is appreciated
additional info
the data im trying to put in starts at the fifth column