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.