Warning msg before macro is activated

[shilpz]

hello

is there anyways i can add a msgbox that would apear which would give a warning asking the user if they would like to proceed forward or not, if the person clicks yes then the macro will activate and if they click no then nothing will happen and msg box wil disapear

The code which i want this msg to com is below:

Range("A17:E20").Select
Selection.Delete Shift:=xlUp
ActiveWindow.SmallScroll Down:=5
Range("F28:I42").Select
Range("I42").Activate
Selection.Cut Destination:=Range("F24:I38")
Range("K26").Select

thanks in advance

[VBA Noob]

Maybe

Please Login or Register  to view this content.

or see link for other examples

http://www.ozgrid.com/VBA/inputbox.htm

VBA Noob

[shilpz]

hello
thanks for your help

but is there something else i was wondering if you could help me add to the code

this Cos deletes 3 rows
i wanted to know if i can tell it that once the range becomes 7 rows long it would not work

adding to the code below

Please Login or Register  to view this content.

thanks in advance

[royUK]

You don't need to Select Rows. Can you explain exactly what the code is supposed to do?

This code should do what your original code was doing.

Please Login or Register  to view this content.

[shilpz]

i have attached a file showing what i mean

i would reli apreciate it if you could help
thanks in advance