Linking two ActiveX comboboxes across different tabs

I am trying to get two Combo boxes to display the same information to no avail. I have several spreadsheets on tabs that I am tracking tasks on. I track the task by clicking on a combo box and selecting, Started, In Progress or Completed. I would like to have a summary page where I can just look over all my projects at once. I would like this pages Combo Boxes reflect the status of the box on the original page. Ideally I would like to be able to change the status on the Summary page and the status would also change on the original page. Any ideas on how to do that? Please let me know if I havent supplied enough information.

hi sgillette01, welcome to the forum, can you post sample workbook?

Both the post a new thread and the go to advanced are broken links right now so I cant upload a excel sheet. At its most basic I am trying to have two combo boxes on two different sheets say the same thing. So if you pick Started on one combo box on sheet one, the combo box on sheet2 says the same thing and visa versa. Thanks for any help in advance!

Hi

Generally activeX controls on worksheets aren't a good idea. Try to use forms controls, if you use a forms combobox your issue becomes trivial as you simply set both comboboxes to have the same linked cell - that way there is no coding required

please check attachment, try to change Status in comboboxes. It is assumed that project sheet has only one ActiveX combo.

If combobox value is not updated, run this code first:

Please Login or Register  to view this content.

@snb Thanks

Why the preference for ActiveX?

@snb
I will give your suggestion a try.

@Kyle123
I am new to this but I used activex because I needed the box to call more then one macro.

Here is my sample sheet. It is just a sample but I think it will give you the idea of what I am trying to do.

Tracker Template.xlsm