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?

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?

Susan wrote:
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?


Yes, I am using worksheet since userforms are way too complicated.

and the rest of the questions?
i can't help you unless you help me.
susan


On Nov 19, 12:20*am, Curious George wrote:
Susan wrote:
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?

Yes, I am using worksheet since userforms are way too complicated.- Hide quoted text -

- Show quoted text -

Susan wrote:
and the rest of the questions?
i can't help you unless you help me.
susan


On Nov 19, 12:20 am, Curious George wrote:
Susan wrote:
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?
Yes, I am using worksheet since userforms are way too complicated.- Hide quoted text -

- Show quoted text -


Its been fixed with changing the Click event to Change, since apparently
method that is called when I click on the listbox items isn't click, but
change. Or rather that I assumed that Click works with every click.

Don't multipost.

"Curious George" wrote in message
.fi...
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?