Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 11-24-2020, 01:21 PM
gmaxey gmaxey is offline Declaring Public variables and accessing in other modules Windows 10 Declaring Public variables and accessing in other modules Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,598
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Charles,




Yes. Why do you use "Let?" You don't need it.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #17  
Old 11-24-2020, 02:09 PM
Charles Kenyon Charles Kenyon is offline Declaring Public variables and accessing in other modules Windows 10 Declaring Public variables and accessing in other modules Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,465
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by gmaxey View Post
Charles,

Yes. Why do you use "Let?" You don't need it.

I know it is optional. I do it to help me clearly distinguish object variables from others. Anytime a value is assigned to a variable I like to do it with either Set or Let. (I often forget, though.)

Last edited by Charles Kenyon; 11-28-2020 at 02:15 PM.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Declaring Public variables and accessing in other modules Combining 3 Modules into 1 Jude24Joy Word VBA 5 02-01-2017 04:20 PM
Declaring Public variables and accessing in other modules Declaring a variable that is known across modules Officer_Bierschnitt Excel Programming 5 11-18-2015 12:28 PM
Array to iterate through variables and trap blank variables Marrick13 Word VBA 5 08-04-2015 06:19 AM
can word: make variables, find appropriate pages, fill out pages with variables, print only those 20GT Word VBA 1 10-15-2014 09:48 PM
Declaring Public variables and accessing in other modules Empty Modules Greg S. Excel Programming 2 07-30-2013 01:38 PM

Other Forums: Access Forums

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