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 <digin...@luukku.com> 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?

Don't multipost.

"Curious George" <(E-Mail Removed)> wrote in message
news:UcFUk.93922$_(E-Mail Removed)...
> 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 <digin...@luukku.com> 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 <digin...@luukku.com> 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 <digin...@luukku.com> 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 <digin...@luukku.com> 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 <digin...@luukku.com> 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.