The activation of the VPS happens instantly whenever your transaction has at least 1 successful confirmation block. The confirmation time depends on the fee that you have paid.