Re: Run a macro and code from the same event?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Let's start at the beginning. What is your macro doing right now? On which
event is it being run? Tell us what you are wanting to do.... we then can
suggest a reasonable approach.
--

Ken Snell
<MS ACCESS MVP>



"Tom K via AccessMonster.com" <u9562@uwe> wrote in message
news:573b8eadd7e20@xxxxxx
> Is there a way to turn my code into a macro? Im much better with macros.
>
> TK
>
> Tom K wrote:
>>The only code Im running or want to run is the code that I noted. I try to
>>avoid code because I dont understand it well enough to use it correctly.
>>In
>>this case I need to run code on the same event (On Current) as where I am
>>allready running a macro. I just need to figure out how to run them both.
>>
>>Thanks for your help.
>>
>>Tom
>>
>>>I noted in my reply that you can run a Public function that is in a
>>>regular
>>>module from a macro. You cannot run a Private procedure (function or sub)
>>[quoted text clipped - 13 lines]
>>>>>>>
>>>>>>> Tom
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200511/1


.

Relevant Pages

  • Re: Closing and reopening the same file
    ... Tom wrote: ... understood by me to mean that you wanted to know how I started "your macro". ... ' Reload the active document. ... Dim wkbk As Workbook ...
    (microsoft.public.excel.misc)
  • Re: Macro problem
    ... Tried your macro to day and it worked without any probles. ... Thanks Tom! ... Sample data was just an example to explain my problem. ... > Sub Macro1() ...
    (microsoft.public.excel.programming)
  • RE: Macro question.
    ... Hey Tom I tried putting it in my module and chaning it to F2 and it's not ... Private Sub Worksheet_Change ... GetValues 'my macro ... a change to cell B9 for example. ...
    (microsoft.public.excel.programming)
  • Re: compare sheets (values and formulas), alert it like spellcheck
    ... "Tom Ogilvy" wrote: ... > Dim rng As Range, ... cell As Range ... >> current sheet that I will start running this macro. ...
    (microsoft.public.excel.programming)
  • Re: Excel 2002 Solver unexpected Error
    ... Hallo Michael, ... Das Macro selber ist nicht passwortgeschützt, ... Extras den Solver aufrufe und gleich wieder schliesse, ... Gruss Tom ...
    (microsoft.public.de.excel)