Update List box

[Swaroon]

Hi,
I have a list box that needs to be set to option 2 before running a macro, here's the main piece of code I am trying to kick off but I can't work out what the command should be eg. I tried and failed with Application.Run

.cboSegments.ListIndex = 2

thanks
Steve

 

[Airfix9]

Should this procedure run when the listbox is changed? If so, add this to the change event for it:

if .cboSegments.ListIndex = 2 then call MyMacro

 

[Swaroon]

Thanks for this, I'll check it out, but maybe I didnt explain properly.

The macro runs by clicking a button, the first command is to ensure that the list box option 2 is selected which is what the code i posted is supposed to do, then it runs the remainer of the macro - what I cant work out is what code is required to get the select option 2 in the list box piece to work.

Thanks for your help

cheers
Steve

 

[Airfix9]

Sorry, not getting it.

To clarify (for me), you have a listbox called cboSegments and you have it populated with a list of items. If they select the item corresponding to ListItem 2 and press the run button, you want the macro to work, is that it? If so, my code should work, you just put that code in the click event for the run button.

 

[Swaroon]

Great, I understand now, I'd put the code in the wrong place - module not the click event for the button.

thanks for your help
cheers

 

[Airfix9]

Also, be careful that you want ListIndex 2 which is the third in the list. The ListIndex usually counts from 0.

 

[Swaroon]

Appreciate the help, cheers