Results 1 to 5 of 5

Automatically activate macro when data is inputed instead of manually activating macro

Threaded View

sonny.thind Automatically activate macro... 03-11-2012, 11:56 AM
abousetta Re: Automatically activate... 03-11-2012, 01:50 PM
sonny.thind Re: Automatically activate... 03-11-2012, 06:15 PM
abousetta Re: Automatically activate... 03-12-2012, 04:50 AM
sonny.thind Re: Automatically activate... 03-12-2012, 08:45 AM
  1. #1
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Automatically activate macro when data is inputed instead of manually activating macro

    I have a spreadsheet(tool.xls) I have created for my associates which helps them to send emails to different managers in the cities.

    all they do is input the different ID# into column B and then click the command button "run" which activates macro "deter" that transposes the emails with a ";" into cell "output"

    I am trying to eliminate the need to use the "run" command and directly activate the macro as soon as the user inputs data into the column B which will automatically transposes the addresses with the ";"

    I am just trying to figure out if there is a way to do this with vba code in the existing macro or use a macro to activate another macro??
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1