There is no relationship between what is in the textbox and a cell. If you
want to update the cell, you need to use the exit event (as an example) of
the textbox to write back to the cell.
Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
With Worksheets("Data")
set rng = .Range("A1:A200")
End With
res = Application.Match(clng(combobox1.Value),rng,0)
if not iserror(res) then
rng(res).Offset(0,1).Value = Textbox2.Text
end if
End Sub
--
Regards,
Tom Ogilvy
"Oreg " wrote in message
...
I noticed that I can view the date & ticket number but am not able to
make changes to the ticket number if needed. Is there a simple way
around this?
Thanks again,
Oreg
---
Message posted from http://www.ExcelForum.com/