vba in commandbutton_click event to only allow to occur in certain cells question

[thecdnmole]

I think this will be a simple answer, least I hope, but I am drawing a blank at the moment! With this very simple code below, how do I prevent this from occurring in a certain range of cells? I've tried "If Not Intersect(Target, Range("sheet1UV")) Is Nothing Then" but it did not work. Thanks for any help!

Please Login or Register  to view this content.

[HaHoBe]

Hi, thecdnmole,

maybe like this (although I would like to have more control over the range the code has to work on as using Selection):

Please Login or Register  to view this content.

Ciao,
Holger

[davesexcel]

Are you able to use code to determine what cells to change, or do you have to use selection?

[thecdnmole]

Thanks HaHoBe! I tweaked it a bit to suit and works great!

Please Login or Register  to view this content.

Davesexcel, I need to use selection, as the person would select one or more cells and then click on the commandbutton to input the P.