how can I use VBA to give user ability to swap rows?

[ArnMan]

Hello,
I have a quick question. I have excel 2010 and want to use VBA in to be able to move a entire row, with formulas and values, up or down and swap with the row above or below

I wonder if I can use arrows like in the pic i quickly made below, so they could click them to move the rows up or down. Most of my spreadsheet is going to be generated by vba code, and this would be a big help.


-- removed inline image ---


Any help would be greatly appreciated.

 

[ArnMan]

Oops I guess the forum didnt like my little bitmap sorry for that