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.