Require help to stop annoying running of macro

Dear friends,
The code is working fine but when I run it and then go to cell g7 or a8 to check the output the macro runs automatically which is very annoying for me. Because of it I’m unable to check the output of it. I don’t want any action while checking the output of it after once running it. In short if there is any value in cells g7 or a8 then no action require until I delete the value in cell g7 and enter a new value in g7.

I want the second output when I delete the value in g7 and enter a new value.

The code is as follows:

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you,

Hi djon5020,
Where is the solution?

Waiting to receive it positively.
Thank you,

You are using the Worksheet_SelectionChange event, so anytime you select a cell in the worksheet, the code activates.
If you want the code to only work when a specified cell is selected, you need to set it up that way, for example.
The below code only activates when you select A8 or G7

Please Login or Register  to view this content.

Hi Davesexcel,
I don't want any change after selecting the cell after running the code first time until I enter another number in g7. I have to check the output of the code and take print out. At this time I dont want any change in these both cells. Next time when I enter new number in g7 then it should change as before.
Please see the workbook which is annoying me and not allowing me to check the output.

Thank you.

Then you shouldn't use the Worksheet_SelectionChange event. Use something else.

The code you are still using is confusing , I don't know what you are trying to do. Also the code does not work fine as you say, every time I opened your workbook, I get worksheet.select errors and global errors.

Hi Davsexcel and Jon,
Thank you. I don't know why the code is giving error from your end. It's working fine and changing the numbers in a8 automatically after entering any number in g7 and hitting enter key or change the cell by arrow key to right direction.

I have added two lines in it to avoide the problem of annoying and changing values in a8 each time after selection but now getting compile error 424 object require in the following code amendment.

Please Login or Register  to view this content.

if you have any new approach to achieve it please do share it with me. Is there any way to change receipt number function into a standard module code so that I will run a macro whenever I need which will be better than automatic after hitting enter key in g7.

Thank you.