Put a predefined name range in to a ComboBox in a Form (VBA)
 

Here is the Create Name code:

ActiveWorkbook.Names.Add Name:=Sheets("Settings").Range("B1").Value,
RefersTo:=Range(Sheets("Settings").Range("B2"),
Sheets("Inställningar").Range("B65536").End(xlUp))

Where the cell B1 contains the name "type".

This means that i got a named range called type containing the cells B2
to the end of the column that have text. this works perfectly... now
the question.


I want to replace this: (this is the question)

UF.combTYP.List = Range(Sheets("Inställningar").Range("B2"),
Sheets("Inställningar").Range("B65536").End(xlUp)) .Value
with this
UF.combTYP.List = Range("type")
or this
UF.combTYP.List = Range("type").value
or this
ActiveWorkbook.Names("Typ").Value
or this
ActiveWorkbook.Names("Typ").RefersToRange

But nothing works...
Please help

UF = User form
combTYP = the combobox

Put a predefined name range in to a ComboBox in a Form (VBA)
 

or this
ActiveWorkbook.Names("Typ").Va*lue
or this
ActiveWorkbook.Names("Typ").Re*fersToRange

should be

or this
ActiveWorkbook.Names("type").Va*lue
or this
ActiveWorkbook.Names("type").Re*fersToRange

Misspelling in this letter