Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2023, 05:34 PM
NicoleJones NicoleJones is offline VBA content idetification Windows 10 VBA content idetification Office 2016
Novice
VBA content idetification
 
Join Date: Jan 2020
Posts: 11
NicoleJones is on a distinguished road
Default VBA content idetification

Not sure if it is possible, is there a way to have VBA code identify if there is anything in document following the point where you are about to insert the macro?
Reply With Quote
  #2  
Old 02-21-2023, 06:54 PM
Guessed's Avatar
Guessed Guessed is offline VBA content idetification Windows 10 VBA content idetification Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Nicole
Quote:
identify if there is anything in document following the point where you are about to insert the macro?
Your question is clear enough to be answerable. VBA code can identify almost anything in the document but 'insert the macro' doesn't mean much. Perhaps you mean at the point where the selection object is sitting when you start the macro.

Maybe try telling us what it is that you want to do and what the user will need to do before triggering the macro.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Content Control content deleted when re-uploading to SharePoint Peterson Word 5 06-27-2018 08:13 PM
Macro to save docx to doc that checks compatibility and converts content controls to static content. staicumihai Word VBA 4 10-12-2016 08:23 PM
VBA content idetification Excel found unreadable content in file.xls. Do you want to recover the content of this workbook? Sanfran Excel 2 10-21-2014 12:09 AM
VBA content idetification macro for change content of cell2 when content of cell1 changes Intruder Excel Programming 1 11-17-2012 08:24 PM
Package for CD with links to Windows media player content and Flash Shockwave content hectorh PowerPoint 4 10-15-2009 12:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:02 PM.


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