Help require to put the code in sheet module to work it automatically

Hi friends,
The code is working fine in standard module but now I want to put it in sheet module to work it automatically after entering a register number in column ‘B’ on Information sheet. Please don’t do any change in code simply do the necessary change to put in sheet module.

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you in anticipation.

Maybe:

Please Login or Register  to view this content.

In the sheet module along with your program

Thank you but I want to put this code in sheet module to run it automatically. Your suggestion is also perfect but I don't want user to click on macro and run it manually so I want to put it in the sheet module.

Thank you.

Just put it in the sheet module

Sorry, The code is missing. Code please!

Hi, mso,

Please don’t do any change in code simply do the necessary change to put in sheet module.

Sorry but for me any change in a cell in Column B should only trigger the necessary alterations for the row(s) in which the event is raised, and this means an alteration to the code. Besides: why have B200 changed and work with your given ranges from row 2 to 90?

Ciao,
Holger

Hi Holger,
Sorry, you are absolutely right. I agree with you. Don't change in code means I don't want to do any change in both formulas. You are free to do any change to put in the sheet module . I agree that it didn't require the cell range 2-90 it will work till the last row.

Please see the attached workbook in which I inserted the code in standard module which is working fine. Please do the necessary change to put it in sheet module to work automatically after entering the reg. no. in column 'b' on information sheet.

Thank you.

Hi, mso3,

maybe try this code:

Please Login or Register  to view this content.

Ciao,
Holger

Hi Holger,
Excellent! Perfect solution.

Thank you and have a nice day.