Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 04-21-2014, 03:14 PM
macropod's Avatar
macropod macropod is offline Excel to auto populate dates based on start and end Windows 7 32bit Excel to auto populate dates based on start and end Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Two problems:
1. You didn't add the macro to your 'Inputs' worksheet's code module. Instead, you created a new module and added it to that.
2. You renamed the macro, from 'Private Sub Worksheet_SelectionChange(ByVal Target As Range)' to 'Sub AutoDate()'.
Both actions prevent the macro running automatically.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel to auto populate dates based on start and end Auto Populate Word From to Excel File webber Word 1 10-02-2013 02:52 PM
Start / End Dates in conjunction with man days loobs40 Project 5 09-19-2013 09:21 AM
how to populate textbox based on combobox selection in word IvanGeorgiev Word 1 02-21-2013 07:32 PM
Excel to auto populate dates based on start and end how to populate textbox based on combobox selection in word IvanGeorgiev Word VBA 1 02-21-2013 07:28 PM
Excel to auto populate dates based on start and end Task Start and End Dates OTPM Project 2 12-04-2011 09:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft