|
-
Mar 13th, 2013, 01:34 PM
#1
Thread Starter
Junior Member
[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
-
Mar 13th, 2013, 01:39 PM
#2
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.
As the 6-dimensional mathematics professor said to the brain surgeon, "It ain't Rocket Science!"
Reviews: "dunfiddlin likes his DataTables" - jmcilhinney
Please be aware that whilst I will read private messages (one day!) I am unlikely to reply to anything that does not contain offers of cash, fame or marriage!
-
Mar 13th, 2013, 01:40 PM
#3
Thread Starter
Junior Member
Re: Excel Add-In: Showing UserControl, VS2012
Ah of course. I knew it was something stupidly simple. Thanks.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|