Generally, yes. The cards and their drivers must be multi-VGA capable, and drivers for the different cards must coexist with each other nicely.
For the former to be untrue, you'd have to go way back in history ... but the latter is easier. So as long as you stick to cards that run off the same set of drivers, it should work just fine.