Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #19  
Old 05-10-2018, 04:23 PM
Guessed's Avatar
Guessed Guessed is offline Changing the names of text boxes Windows 10 Changing the names of text boxes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
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

If you are getting variance like that then it is pretty pointless pursuing incremental gains in speed unless you are running this 10+ times a day. However it is always worth learning more efficient ways of coding.

I don't know why the status bar push isn't working (it does work on my machine) but perhaps you could try other characters. eg
StatusBar = String(50, Chr(151)) & "Macro status: " & shapecount & " of " & AllShapes
StatusBar = String(50, Chr(160)) & "Macro status: " & shapecount & " of " & AllShapes
StatusBar = String(50, "_") & "Macro status: " & shapecount & " of " & AllShapes

My guess is that the problem with the first text box being missed is that the alt text is not EXACTLY correct. A space either before or after the visible text would be enough to skip over it. Try this as a modification to avoid that type of issue
If Trim(LCase(oShp.AlternativeText)) = "shrink" Then
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing the names of text boxes Formats in text boxes in Word 2016 changing unexpectedly PugwashAtNPEU Word 4 05-04-2017 05:53 AM
Changing Default Fonts for Text Boxes and Tables LadyBug679 PowerPoint 2 04-01-2016 06:42 AM
Changing the font colour in all text boxes marqives Word VBA 1 11-25-2014 06:05 PM
Changing the names of text boxes Changing the placeholder text for drop down boxes DeadBatteries Word 1 08-24-2012 09:09 AM
Changing the names of text boxes Arrows and text boxes disappear when changing view? Jesse Word 4 06-12-2012 05:28 PM

Other Forums: Access Forums

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