Your question is not clear and hard to understand. I'm not sure you are using InfoPath in the way it was intended.
InfoPath is a tool to display XML data in a visually appealing way. There is no immediate connection between InfoPath forms and Excel tables.
InfoPath forms can be filled in and stored in a database or in a SharePoint library. The stored data is just the XML. If the record is opened with InfoPath filler, the form shows as designed with InfoPath Designer.
If you have an Excel spreadsheet and a VBA User Form to enter data, that Excel form can NOT be transformed into an InfoPath form automatically. InfoPath is totally separate from Excel and operates in a completely different universe.
I work with both InfoPath and Excel on a daily basis. If there was an easy way to translate an Excel form into InfoPath, I'm sure I'd like to know about it, but AFAIK it does not exist.