Returning Values By Reference in Ribbon Callbacks
To return a value from a ribbon callback, you need to pass the value back to the calling procedure using an argument that has been passed by reference. —  By Mike Wolfe (connect on Twitter: @NoLongerSet) This article is one in a series on Subs vs. Functions in VBA. One of the “additional facts” from my Subs vs. Functions article was this: Sometimes you MUST use a Sub, even if you do need its return value (e.g., ribbon callbacks).
Returning Values By Reference in Ribbon Callbacks To return a value from a ribbon callback, you need to pass the value back to the calling procedure using an argument that has been passed by reference. —  By Mike Wolfe (connect on Twitter: @NoLongerSet) This article is one in a series on Subs vs. Functions in VBA. One of the “additional facts” from my Subs vs. Functions article was this: Sometimes you MUST use a Sub, even if you do need its return value (e.g., ribbon callbacks). Software-Development
Returning Values Reference Ribbon Callbacks return value ribbon callback need pas value back calling procedure using argument passed reference — Mike Wolfe connect Twitter NoLongerSet article one series Subs v Functions VBA One “additional facts” Subs v Functions article Sometimes MUST use Sub even need return value eg ribbon callback SoftwareDevelopment