Constant execution of ListBox.Click

C

Curious George

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?
 
S

Susan

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
 
C

Curious George

Susan said:
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
Click to expand...

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

Curious George

Susan said:
and the rest of the questions?
i can't help you unless you help me.
susan
Click to expand...

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.
 
Top