Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-04-2022, 04:51 AM
Guessed's Avatar
Guessed Guessed is offline Returning Boolean Windows 10 Returning Boolean 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

Your code has two different variables called bln - one in the sub, one in the function. If you defined bln once at the top of the module (above the sub) then it would exist at the module level and you would have only one bln and therefore could use and reassign it anywhere in the module.

Alternatively, you pass the variable's value back to the sub by changing the commented line in the function to...
Code:
strr = True
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Returning Boolean Loop through Multiple Boolean Variables ScottyBee Word VBA 8 03-25-2019 03:24 PM
Formula returning zero allex011 Excel 2 12-03-2018 02:30 AM
Hard Returning Phil H Excel 2 05-15-2018 03:29 AM
Returning Boolean Returning a whole row kevskisa Excel 2 07-28-2015 03:19 AM
Returning Next Record to the top bordercollie10 Mail Merge 0 02-26-2009 09:06 AM

Other Forums: Access Forums

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