On Jun 2, 5:00*pm, Dave Peterson wrote:
Does this mean that you got it working?

I can't tell.

dtshedd wrote:

<<snipped

Thanks everyone for the help. *Acrtually I started using c.Caption
without ".Text " but this *did not work either probably because I used
a "+" concatenation *operator.

--

Dave Peterson

Sorry for not responding sooner, I had to wait to go back to work to
try it. Unfortunately these changes did not fix the problem.

while in debug stepping thru the code behind the form, everything
works and using the Application.WorksheetFunction.IsText function i
confirm that the variable mybins is text, however the minute control
is returned to the regular code module the string is null and it fails
the istext test.

out of ideas