HI again Defcon 3Originally Posted by defcon_3
No worries I just saw your post and made it really quick with your provided code not tested but pretty sure will work. I forgot to add cancel but I guess you figure it outcheers.
Yes your right, your code does work, just to improve it a little I added the line: Found.EntireRow.Cells(3).Activate before your msgbox so that the cell in question is selected before the routine pauses.
As you noticed I added Cancel, but effectivly with the way I coded it , it is the same as choosing No.
- I now will study the circumstances more and try to abbreviate my code, if I can see how to, by closely looking over your code.
- Even if I don't use your style of msgbox right now, I know I will somewhere down the road, as it's a more streamlined approach.
- I surely appreciate your time
Reply With Quote