Combo box macro question

[robfo0]

Hi everyone.

I was wondering if there is a way to change the cell link of a named ("CMB_BOX1") combo box using a macro? Say for example it is now unlinked, i would like a macro to link it to cell a1 (which contains a "2") and have the combo box update, so that it displays the 2nd name in the list (already linked).

Can i do this all with a macro?

Thanks

 

[Ivan F Moala]

On 2002-05-08 18:29, robfo0 wrote:
Hi everyone.

I was wondering if there is a way to change the cell link of a named ("CMB_BOX1") combo box using a macro? Say for example it is now unlinked, i would like a macro to link it to cell a1 (which contains a "2") and have the combo box update, so that it displays the 2nd name in the list (already linked).

Can i do this all with a macro?

Thanks

Forms Combobox ?? then Try

ActiveSheet.Shapes("CMB_BOX1").ControlFormat.LinkedCell = "$A$1"