Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2018, 12:24 PM
trevorc trevorc is offline Adding default text to notes with VBA Windows 7 32bit Adding default text to notes with VBA Office 2013
Competent Performer
Adding default text to notes with VBA
 
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default Adding default text to notes with VBA

Hi All,
Is it possible when creating a cell note to add/change the default text. Currently it opens up with my name in there, I'd like it to start with the current date in stead.


Or can I create VBA for when a note is created to auto add this.
Reply With Quote
  #2  
Old 11-20-2018, 01:05 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Adding default text to notes with VBA Windows 7 64bit Adding default text to notes with VBA Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Does this help ? https://www.contextures.com/xlcomments03.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 11-20-2018, 01:52 AM
trevorc trevorc is offline Adding default text to notes with VBA Windows 7 32bit Adding default text to notes with VBA Office 2013
Competent Performer
Adding default text to notes with VBA
 
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

Thanks for the link, it goes a long way to helping me determine what i can/can't do. I did have some of that already but can improve on it some more now.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding default text to notes with VBA Turn OFF auto-adding file path as default alternative text for inserted objects Sergey SPb Drawing and Graphics 7 04-24-2017 11:25 PM
PowerPoint 2013-Position and formating of Notes Text Box Desiderata PowerPoint 0 03-14-2017 01:31 PM
Is it possible to put notes to the *side* of the slide on notes view? (PPT 2007) asvm39 PowerPoint 1 03-22-2016 02:02 AM
Adding default text to notes with VBA A way to change the different color for different notes of a text tesoke Word 11 07-08-2015 07:20 AM
Adding default text to notes with VBA Setting text to redirect between notes Diogenes OneNote 4 03-23-2015 03:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:11 AM.


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