Thanks.
Not sure of the vBa feature, but in PhotoPlog, you can allow your members to suggest a category. Once you approve the category, it's available for uploads. If you are looking for that category to be used only by said member, that'll be a feature request maybe for a later version of pro.