Thanks Paul,
Its working.All I need to it is to call the function that populates the
combo in the Sheet's activate event.

Paul Lautman wrote:
ST wrote:
I load a combo in sheet 2 and load it with data in sheet 1.Is there a
way where the combo can be refreshed automatically if I change the
data in sheet1?
Any help?VBA code needed..
Thanks


ST

I use the worksheet_activate event for this. Since you will not see the
combo till you actually go to sheet2, put a worksheet activate event on
sheet2 that refreshes the box.