unbale to change a cells based on textbox value

[9599lorenzo]

dear all ,

I use the following code to find a textbox2.value (user form) in column B of the active sheet .

once the value is find then I wll run a macro that updates the offset cells based on the various textboxes values I have in the userform .

the problem is that the values in the various textboxes are correctly transferred to the activesheet and in the correct place , the only cell that is not copying is the one that I was looking for in textbox 2.....
the line is not updating the cell is highlighted in red

Please Login or Register  to view this content.

[Leith Ross]

Hello 9599lorenzo,

The problem must be somewhere else in the code, since the syntax is correct. Please upload a copy of the workbook for review. Seeing all of the code should provide clue as to the problem.

[9599lorenzo]

dear ross,

tks so much for help.

I have attchd a sample workbook .

just click the button an a user from pop up ....

what I need to do is insert a text in the textbox than hit find button and if value is find a msg box wll pop up .

then I need to change the textbox value and hitting the button "replace" the changed textbox should be now
copied in the previous found cell.

hope is clear

tks
Lorenzo

[Norie]

The code you posted isn't in the workbook you attached and the userform in the workbook only has one textbox.

[9599lorenzo]

yes I just create a copy right now because the entire workbook is full of details macros etc etc and not easy to undertand ......if you wand I wll attch my original one....

[9599lorenzo]

..here attch my real workbook.....

press ctrl+Q and the userform wll pop up .
then in the fieLd "MAWB" type something you want to search for in column B .
then hit display and the userform wll capture all the row informations.
after that if you modify the fields in the userform and then hit "CHANGE" everything is correctly transpose to the
sheet except when you try to change the textbox2 (MAWB FILED) .BOOKING LIST test.xlsm

[Norie]

If you change what's in the MAWB field then the Find in the code for the Change button will fail so the code that writes the data back to the sheet will be skipped.

Perhaps you should store the row for the current record somewhere and use that in the Change button code.

[9599lorenzo]

ok...tks ..any ideas on how to store the record?

many tks