Excel-DNA / Excel-DNA/ExcelDna

Access To Controls

Open
#303 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.