I've used VB slightly, but never gotten familiar with VBA. Is it possible to create a form that a user can input a string of data into, then parse that the integers out of that string into the next blank cell?

Example: ID: #15149, Budget: 2 cr, agriculture: 0, mining: 0, processing: 0, production: 0, physics: 0, chemics: 0, medical: 0, weapons: 1, drives: 0, construction: 0

Parsing this would return 15149, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0 into row n(next blank row), columns a-l.

Or is there some way to set agriculture, mining, etc as constants and return the integer following them to the next blank cell?