Dont bother with the module. They often stuff up and then the aerial goes straight back down again... wont stay up.
Also aftermarket aerials arent compatible with the VN module anyway, so you would need a genuine aerial... Grab an Aerpro aerial for less.
Wire the aerial straight to the radio... When the radio is turned on, aerial goes up, radio is off, aerial goes down. But yeah the buttons wont work on your console to put it up and down, but they wont work proprerly with an aftermarket aerial anyway as I said before.
But if you really want it to work...Genuine aerials are like $160 or something (Aftermarket Aerpro ones are between $90 and $99)
Aerial modules you're lookin at $40-$50 from a wreckers or spare parts place normally. The wiring should be there already, it should be able to be plugged in inside your passenger side kick panel and up next to the glove box... Just a matter of locating the plug.