Solved

VB.net Excel Add-In msoControlPopup is not declared

Posted on 2014-10-29
2
217 Views
Last Modified: 2014-10-29
Hi
In the following line in my VB.net Excel Add-in I get the error  "msoControlPopup is not declared"
 Globals.ThisAddIn.Application.CommandBars("Cell").Controls.Add(msoControlPopup, Id:=1)
0
Comment
Question by:murbro
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 40410838
It should be:

       
Globals.ThisAddIn.Application.CommandBars("Cell").Controls.Add(Type:=Microsoft.Office.Core.MsoControlType.msoControlPopup, Id:=1)

Open in new window


I believe.
0
 

Author Closing Comment

by:murbro
ID: 40410856
Thanks very much
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Footer for each row on Gridview 2 21
Move data from one sheet to another 11 36
vba autofilter in row 4 6 11
excel count months in date range 6 12
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question