View Single Post
 
Old 02-28-2024, 08:05 AM
gmaxey gmaxey is offline Windows 10 Office 2019
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

You are getting a runtime error because your are trying to set a string variable to a variant variable.


Change ctrlTitle() as String to just ctrlTitle
or
Change Array("Name", "Position" , "Etc") to Split("Name,Position,Etc", ",")


Now sure you don't want a msgbox popping up every time your code finds a CC with content.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote