[RESOLVED] Excel Add-In: Showing UserControl, VS2012
So I'm working on learning VB.Net and VBA as additional languages. I must clearly be missing something simple from the MS example, because I can't seem to get my user control to pop up:
Code:
Private Sub ControlPannel_Click(sender As Object, e As RibbonControlEventArgs) Handles ControlPanel.Click
Dim controlpanel1 As UserControl1
controlpanel1 = New UserControl1
controlpanel1.Show()
controlpanel1 = Nothing
End Sub
UserControl1 is just the standard user control with tabs and a list box, dropped in it. It runs without an error, but nothing pops up.
My eventual goal is to have a user control (or some other window) pop up, and allow the user to input instances from an Access Database in the active worksheet.
Thanks
Re: Excel Add-In: Showing UserControl, VS2012
If it's a control it must be added to a form. It doesn't do 'pop-up' from .Show which is a command for forms.
Re: Excel Add-In: Showing UserControl, VS2012
Ah of course. I knew it was something stupidly simple. Thanks.