This has probablly been answered before but does anyone have any sample code
show how I would go about moving the locaiton of a combo box dependent on
where the user clicks. I know it's probablly going to involve the
SelectionChange event of the worksheet but I can't seem to get the combo to
display in the new location.
Sample code to follow::::

if (cbo1 != null)
{
Globals.Sheet1.Controls.Remove(cbo1);
cbo1 = null;
}
selection = Target ;
cbo1 =
(Microsoft.Office.Tools.Excel.Controls.ComboBox)Gl obals.Sheet1.OLEObjects(name);
cbo1.Tag = Globals.Sheet1.Controls.AddControl(cbo1, selection,
name);
cbo1.Name = name;
cbo1.Activate();


Thanks in advance..
Jimm