Setting Combo box Range for Worksheet Control

[Limits]

For the Format Control Input Range for the list source of
a combo box, is it possible to use a variable? If so, a
simple example would be appreciated.

 

[Doug Glancy]

Limits,

For example, insert a range into your sheet named "tester". Then enter
tester (without quotes) into the input range box.

hth,

Doug

 

[Limits]

Is there a way to do this through a variable set within
the assigned Macro?

 

[Dick Kusleika]

Limits

A range variable?

Sub fillcb()

Dim rng As Range

Set rng = Sheet1.Range("A1:A4")

Sheet1.DropDowns(1).ListFillRange = rng.Address

End Sub