Excel-DNA / Excel-DNA/ExcelDna
Access To Controls
- Dominant language
- C#
- Stars
- 1.5k
- Forks
- 292
- Avg merge
- 20d 12h
- Merged PRs (30d)
- 1
Description
Hello,
I am trying to create a ComboBox for my addin. I came across this:
https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.tools.excel.controls.combobox?view=vsto-2017
Which requires me to have access to my worksheet's controls. Is this possible with Excel DNA?
From my understanding, controls are accessible as from Globals, which Excel DNA does not expose.
Is it possible for me to get access to Controls in Excel DNA? Or is there another way I can make the ComboBox?
Basically, I need a dropdown that will be pre-populated with some values. Data Validation won't work because the dropdown characteristic doesn't show unless the cell is selected. I'm also not sure how to handle the changing of values in a validation.
Thanks
Contributor guide
Assessment
This issue has not been assessed yet.