Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 11-14-2021, 09:55 PM
Guessed's Avatar
Guessed Guessed is online now Help with Extraction of Text in 1 TextBox only Windows 10 Help with Extraction of Text in 1 TextBox only Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
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

The purpose of the If statement is to avoid the macro erroring if you didn't already have a shape selected. Putting your extra line down there will throw an error if that is the case since there won't be a first object when there are no objects.

It would be better to include that line just before the End If line
aShp.Delete
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 

Tags
extracting data, help please, textbox

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Log file extraction xendistar Excel 0 09-01-2016 02:08 PM
wrapping text around a picture within a textbox ketanco Word 3 04-06-2016 11:07 AM
Help with Extraction of Text in 1 TextBox only Data extraction from a cell! JTevez Excel 2 10-14-2015 11:56 PM
Help with Extraction of Text in 1 TextBox only Display result in textbox based on the input of another textbox scarymovie Word VBA 5 05-16-2012 07:05 PM
Help with Extraction of Text in 1 TextBox only Email Extraction dpad Outlook 1 08-17-2010 06:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 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