under what conditions do you want it to fire? what event would
trigger the code?
is the listbox in the worksheet, or is it in a userform?
yes, you can probably do what you want, but you have to give it some
parameters. i don't know if you'd need worksheet_change or
worksheet_selectionchange. answer the questions and maybe me (or
somebody else) can figure it out for you.
:)
susan


On Nov 18, 3:03*pm, Curious George wrote:
How do I constantly make events fire, like ListBox.Click subroutine.
Currently I can run the result only by executing the macro run button
thingie. Cant I make the VBA work all the time without pressing any
buttons to run the code?