I created a form, from an excel list with different formats, text,
dates, currency.
by filling in the form, I can add lines in the excel sheet.
The next step I would like to do with the form, is to find lines from
the same excel sheet, so that data of that row is filled in the right
boxes again, make it possible to change the boxes or add info in empty
boxes and paste it back at the correct line.

1.I am trying to work with VLookup function
txtcustomer.Value = WorksheetFunction.vlookup(txtmovexno.Value,
Range("A:N"), 2, 0)

and for some textboxes it works and I see the correct info back, but
with the same formula I receive error message 1004 for other txtboxes.
I think the formula would be correct. Could it be the problem that the
format is not correct?

2.Is there perhaps an easier way to find, adjust and replace the
existing info in the rows in excel with a form?

I hope someone can advise me with this. (already breaking my head for
days already, can't sleep ;) )

Thanks,
regards,
Claudia


--
Claudia
------------------------------------------------------------------------
Claudia's Profile: http://www.excelforum.com/member.php...o&userid=37332
View this thread: http://www.excelforum.com/showthread...hreadid=570323

I know I did wrong with the formula, I was working with two sheets and
range of first one was shorter then second one and I did not change it.


but second question remains.
Now I have all the info in the form in the correct boxes, but how can I
paste it back after changing of adding some boxes in the correct row?

thanks


--
Claudia
------------------------------------------------------------------------
Claudia's Profile: http://www.excelforum.com/member.php...o&userid=37332
View this thread: http://www.excelforum.com/showthread...hreadid=570323