Code to change LinkedCell of ActiveX ComboBox

**ozhunter** · 06-08-2011, 06:23 AM

Hello

Can someone help me with some code that will change the Linkedcell of a ComboBox when I want it to. I would like to link it to a button so the LinkedCell won't change unless the button is clicked.

Current LinkedCell is Sheet1!A1

Thanks

**snb** · 06-08-2011, 06:34 AM

Please Login or Register  to view this content.

To make it more dynamic:

Please Login or Register  to view this content.

**ozhunter** · 06-08-2011, 06:40 AM

Thankyou snb

I realised as I saw your post that I hadn't fully explained myself.

I would like it to change to the cell below ie from A1 to A2, and the next time the button is clicked it changes form A2 to A3. I tried offset, but I'm missing something.

Adam

**snb** · 06-08-2011, 06:47 AM

Here you go:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**ozhunter** · 06-08-2011, 07:10 AM

snb

You are very good at this stuff. After I put my brain in gear I got your code to work, thank you.

As my workbook progresses, I'm sure there will be other questions.

Cheers

Adam