Combo box how to

[paulmtl]

Hi all,

How to use combo box in the Excel workboot ?

empno:
11111
22222
33333
44444

in order to select empno from combo box

Thanks in advance

 

[SkipVought]

Hi,

In what application?

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[paulmtl]

In the Excel workbook

 

[SkipVought]

In Excel there are 2 kinds of controls that you can place on a worksheet: Forms & Control Toolbox.

Forms controls are easier to use but have fewer properties that you can comtrol -- easier to use because you may not need any code to do what you want to do.

Control Toolbox controls need VB code for any event.

Right click on the Excel toolbar and select either Forms or Control Toolbox.

Both controls will take a range in
[tt]
Input Range
ListFillRange
[/tt]
I like to use Named Ranges -- How can I rename a table as it changes size faq68-1331

There is a difference in determining the result.

In a Forms combo, you get the List Index value in the Linked Cell. You'll need to lookup the string value using =INDEX(YourList,LinkedCell,1)

In the Control Toolbox combo, the Combobox1_Click event can be used to determine the value selected

Private Sub ComboBox1_Click()
   msgBox ComboBox1.Value
End Sub

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[paulmtl]

Hi Skip,

Perfect to built combo box, I can select 11111 from combo box and how to past that to the new cell ?

TIA

 

[SkipVought]

Private Sub ComboBox1_Click()
  With ActiveSheet
    .[A1].Value = .ComboBox1.Value
    .Cells(1, 1).Value = .ComboBox1.Value
    .Cells(1, "A").Value = .ComboBox1.Value
  End With
End Sub

all statements do the same thing

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}