View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Userform cannot return any values

Note my example was incorrect as well

Dim varr() as Variant


should have been

Public Varr() as Variant

--

Regards,
Tom Ogilvy

"Nick" wrote in message
...
Thanks Tom - I thought of that but it didn't work.

Double checking I found that I had only 'dimmed' the array
outside of subs in the general module rather than using
the public keyword.

I feel rather stupid now : )

Thanks anyhow

Nick