Use a VB.net userform in Excel 2007
Posted on 2012-09-14
I have a very complicated workbook that runs a business simulation using multiple sheets and lots of VBA modules. I am trying to make this look more professional by having the user interface based around userforms that access the worksheets (with Excel minimised and running only in the background).
Of course, this presents problems with the limited controls that can be used in VBA userforms. I have managed to create menubars and simulate things like mouseovers, etc. using lots of code, but it is still nowhere near as good as a VB.net userform.
I keep seeing in forums where experts have said "why not just create the userform in VB and export it to excel" (or words to that effect).
My question/s...is this even possible? Can it be done as an addin? Would I still be able to access cells, etc. in the main workbook (where all the calculations are done)? And, lastly, how do I do it?
One day, I will get around to programming the whole thing in VB, but there are literally thousands of formulas and interactions and excel is great at handling the complexity of this type of simulation.
In the meantime, any advice would be greatly appreciated.