how to refer dropdown control in excel sheet using VBA

[kiransalu]

It shows three properities
Input Range
Cell link
Dropdown lines.

Now i want to dynamically set the input range for this control. When i go VBA i couldn't find the name of this control. how do i set the range during run time.

 

[SkipVought]

Hi,

WhatSheet.shapes("MyDropDown").OLEFormat.Object.ListFillRange = "MyRangeName"

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!}

 

[kiransalu]

Wow. Excellent. It's working now.

Thank you very much.