Thanks
Is it better to have the most subs in module
and can i have as many subs i want in one module

"JMB" wrote:

A sub in the same sheet? Is the sub an event handler or just a regular
macro? If it's just a regular macro I'd move it to a regular module (I don't
think VBA looks for plain-vanilla macros in the sheet modules). If you're
trying to call an event handler, can you move the guts of your second event
handler to a macro in a standard module and replace with a call to the macro
(ie both event handlers would call the same macro).


"aran" wrote:

Hello thanks
that seem to work on macros but if i like too run a sub in the same sheet

"JMB" wrote:

try using

Application.Run (MacroName)


"aran" wrote:

hello
i have a combobox were i chose a value and like to run a sub
were the name of the value is the name of the sub
how do i do