We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to list out all sheet names of the workbook in a excel combo box?

This article explains how to list out all sheet names of a workbook in an Excel combo box using XlsIO.

What is the use of form controls?

Form controls are used to easily reference and interact with cell data without using VBA code, and when you want to add controls to chart sheets.

To know more about usage of form controls with XlsIO, please refer the documentation.

Code snippet to list out all sheet names of a workbook in a combo box

 

C:\Users\kondurukeerthi.kondu\AppData\Local\Microsoft\Windows\INetCache\Content.Word\ComboBox_SheetNames.pngCombo box with sheet names of a workbook

Applicable properties of a combo box

Below is the list of applicable properties for a combo box.

1.  ListFillRange

2.  LinkedCell

3.  SelectedIndex

4.  DropDownLines

5.  Display3DShading

 

Download complete sample

Download input file with data

The following C#/VB complete code snippet shows how to list out all sheet names of a workbook in an Excel combo box using XlsIO.

C#

 

VB

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8503 02/28/2018 02/28/2018 Windows Forms XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.