Message box in a reset button

[RJ1969]

Hello all,
can you please fix my reset button code.
In cell J4 I have a message box after I do an entry and then it goes into the next cell.

After all my entry there is a reset button that I click to reset all my entry. But when I click the button box, the message box appear.
The Range("J4").Select is added for a good purpose. I want my cursor to return in J4 after I click the button.

Here is the reset button code I have in the VBA.

Please Login or Register  to view this content.

[Logit]

.
I don't understand your comments about the MsgBox .... however, I believe this is the macro you are seeking :

Please Login or Register  to view this content.

[RJ1969]

Hi
sorry... I didn't work.

[RJ1969]

In cell J4 I have a message box after I do an entry and then it goes into the next cell.

Please Login or Register  to view this content.

After I do all my entry, there is a "reset button" that it clears all my entry in the cells. But when I click the reset button, it appears the message box.

Please Login or Register  to view this content.

[Logit]

.

Please Login or Register  to view this content.

[RJ1969]

Hi
When I click the reset button it does not appear the message box. Its good but now Every time I do an entry on each cell J4,AI5,C8,C14,C20, the message box appear.

[Logit]

.
Tested and works here :

Please Login or Register  to view this content.

[RJ1969]

Yay! It worked. Thank you so much.

[Logit]

.
You are welcome. Glad to help.

[RJ1969]

Hi
Do you think you'll be able to remove the gray color on these cells?
A1,A2,B2,C3

I have been trying to ask everyone but I can't get no answer.
But if no, no problem. I pretty almost complete my project except I can't get rid the gray color.


Thanks.

[Logit]

.
This portion of the Worksheet_SelectionChange event is controlling the coloring of those cells:

Please Login or Register  to view this content.

If you delete that portion of the macro, the coloring should disappear.

[RJ1969]

Hi...
I don't know what to do. Still does not work.
I took the selection out from the code then the tab stop working.

Private Sub Worksheet_Change(ByVal target As Range)

Thanks.

[Logit]

.
I included too much code in my last post of what to remove.

Keep this portion :

Please Login or Register  to view this content.

REMOVE this part :

Please Login or Register  to view this content.

Seems to work well here. Does it function well there ?

[RJ1969]

Hi
If I removed this part then my tab order disappear. I will not longer have the order as I want for my tab :o(

[RJ1969]

Check this out (see attachment) I created another one. This work perfect for me. But you may be able to resolve it.
The only problem with this is that when I press the tab/enter key if keeps hitting the check box.
I need to be able to just click the box but be able to tab it order that it only goes in A1,B2.

How do I skip hitting the check box?

[Logit]

.
This arrangement of your existing code removes E8 & E10 from the tab sequence :

Please Login or Register  to view this content.