If range value greater then 0 then show msgbox with cell value

[HaroonSid]

hi,
i am using worksheet change event to appear a msgbox if range m3 value >0

Please Login or Register  to view this content.

i want msgbox show cell value of range f10:f1000 and activate the same row of range f10:f1000 and clear the input value of range f10:f1000 of range m3 got greater then 0

thank you

[coreytroy]

Sorry but your descrption lost me at, 'want msgbox show cell value of range f10:f1000'
You want a msgbox to show 990 cell values?

[HaroonSid]

no
Only active cell value

for example'
i type 17 in range f11 and range m3 value goes greater then 0 then show msgbox with "value not found' and 17(cell value) and then clear the 17 from

thank you for the reply

[coreytroy]

Untested, but something like:

Please Login or Register  to view this content.

[HaroonSid]

An error comming and sorry
this is not what i need bro
Capture.JPG

[HaroonSid]

what i need
for example'
in above mine code if range m3.value > 0 then msgbox will show
so i need changes in above code according

i type 17 in range f11 and (range m3 value goes greater then 0 ) then my code will show a msgbox with

Please Login or Register  to view this content.

i want to added the cell value where msgbox shows and clear the value of that cell

thank you

msgbox "value not found' & cell value (17)

[jindon]

for example'
i type 17 in range f11 and range m3 value goes greater then 0 then show msgbox with "value not found' and 17(cell value) and then clear the 17 from

thank you for the reply

Please Login or Register  to view this content.

[HaroonSid]

Perfect
code Jindon Sir

thank you