Adding a private sub to existing macro w/ userform

[EllenTulloch]

Hello!

We've got a macro at work that formats a variety of different files from our vendors into a single format for upload. When we add a vendor or the vendor changes formats, we have to update the macro accordingly.

I'd like to create a userform so the team members with 0 VBA experience can easily add a new format and/or edit an existing format. I've got a standardized private sub that needs the ranges identified and a few other things checked.

Can I trigger a new private sub creation within a macro/edit that private sub WITH a macro? I figure if it is possible to do in VBA, I can figure out how to incorporate that into the userform coding.

Thanks!
ET

 

[Saurabhj]

Hi ET, yes you can create a new sub procedure and call that using call <subname>.