I have a form designed in VB.NET, which I need to populate from VBA Excel.
1) I open the form and initialize its object from VBA
2) Adding an item to ComboBox2 (of the VB.NET form)
3) VBA editor translates its to - adding a space before(f.Name)
4) It returns an error Object required
The problem is that
is a VB.NET syntax, which foreign for VBA, that's why it ads a space
How can I fix this? Of course, i can call a special macro inside VB.NET, but it would make it more difficult