Auto complete combobox on sheet

[Opus]

I would like to ask if any on knows wher I can get some VBA to Auto complete combobox on sheet, but what I will ask is, is it possible and if I have to use ActiveX how do I do that?
Excel 2003 XP

 

[Opus]

Found I think I need to use a Data Validation Combo box using Named Ranges but still I would like to have a combo box that the user can select from but now I need a Dynamic Named Range I have a header , data starts Cells(2,1) and has dynamic columns and rows, not all cells are >0 for columns but row1 column 1 is always >0, cells contain text and numeric.

Can any one help, I know it's proberbly easy but your replies help and if you don't mind I would like to discuss the code so I learn and stop asking stupid Questions

 

[Opus]

Dynamic Named Range

I need to learn how to set a named range, where is the best place to learn this?

Sub DRange()
Dim NumRows As Integer
Dim Data As Range
Dim Suppliers As Worksheet
Set Data = Range("A2:T")
NumRows = Data.Rows.Count
Suppliers.Data.Resize(NumRows).Select
End Sub

Am I on the right track? and how would I name the work sheet.

Thanks

 

[rs2k]

Re: Dynamic Named Range

Opus,

I find find it very difficult to figure out what you are asking. Do you want to populate a combobox?
Do you want a combobox to show the the list when new items are added?

Colin

 

[Opus]

Both but a control combo box. Sorry if I am difficult to understand I realy don't mean too be.
1 How do I conect a named range "NAME" to a control combo box?

 

[rs2k]

is the combobox on a worksheet?
if so, in the properties, 'Listfillrange' use the name of the named range.

if it is on a userform use the 'Rowsource' property

Colin