I have a list box, and when a different option is chosen from the list, I
need to either

a) create a macro that pops up a dialogue box to remind the user to press
some buttons to update the data,

or

b) create a macro that just goes ahead and updates the data.

I've already written the macros to update the data, I just can't figure out
how to join it up with the action of choosing a different option from the
list box. Any ideas?

Thanks in advance for your help.