Selecting an Item in a ComboBox with a List Created from RowSource

[shona_jk]

I've got a combo box which is populated from column A from sheet 1. I am linking each item in that combobox to a Macro. I don't want to hardcode it like this....

If ComboBox1.Text = "Early Years" Then Call EarlyYears

Is there a way I can link it from the cell it came from.....so for example "Early Years" came from A8. Incase that title changes I want the coding to be flexible and accommodate that change.

Can anyone help?

[Kyle123]

Maybe:

Please Login or Register  to view this content.

[shona_jk]

But wouldn't I still have to put the text "Early Years"? I want to be able to refer to the "Early Years" cell A8.

[Kyle123]

I though that you were just trying to run a macro that has the same name as the selected item in your ComboBox, is that not what you're trying to do?

[abousetta]

I'm not clear on what you are trying to do but maybe:

Please Login or Register  to view this content.

[shona_jk]

No sorry perhaps I didn't explain well enough. I have a combo box that I've got a list in which has come from a table in an excel sheet. I want to link each item in the list to a macro, but in the code I don't want to refer to the text in the combo box (ie. early years) as this might change in the future but instead want to refer to the cell that each item is in (ie. A8). If I put the text in the code then I will always be changing the code. Want it to be more flexible.

[Kyle123]

That's what mine does (I think ) it runs a macro that has the same name as the selected item in the combobox.

[shona_jk]

The macro's don't have the same name as the item in the combobox.
I have a list of project in column A: ie.

Column A
Project A
Project B
Project C

The combo box list has been generated from this column. The projects will change or be removed so the list in the combobox will change.

The code I've used currently is:

ComboBox1.Text = "Project A" Then Call ProjectA (although the macros have the same name for this they don't all and won't in the future if the project changes in Column A)

So because the list will change I don't want to reference "Project A" (in red above) in the code instead

[shona_jk]

Oops sent that too soon.

...in the code instead I want to reference the cell that "Project A" is in, that way if it changes to "Project G" the programme will still work.

[shona_jk]

Oops sent that too soon.

...in the code instead I want to reference the cell that "Project A" is in, that way if it changes to "Project G" the programme will still work.

[HSV]

Maybe this is a way if I understood the question correctly.

Please Login or Register  to view this content.

In standardmodul.

Please Login or Register  to view this content.

[Kyle123]

So you want to always run the same macro for the first item in the list, the second macro for the second item in the list and third macro for the third item in the list etc. regardless of the text in combobox? If that's the case you can use HSVs code if the macros are numerically incremented.

[shona_jk]

So is "HSV" the macro?
And is ListIndex + 1 the first cell A1? So would Cell A2 be ListIndex +2?

[shona_jk]

Kyle, yeah that's right. Could someone explain what HSV is please?

[HSV]

Here is an example shona.