View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
plh plh is offline
external usenet poster
 
Posts: 48
Default User Defined type as Sub parameter?

I would have thought this would be OK:

Dim NewOrder As udtNewOrder
'In the public area. udtNewOrder is a User Defined Type

With NewOrder
...
...
...
RecalculateRawMaterial (NewOrder)
...
...
...
End With

Sub RecalculateRawMaterial(udtNO As udtNewOrder)

'DoSomething

End Sub

But I get: "Type Mismatch"

I seemed to recall there was something funny about udt's as parameters, but
damned if I can recall...
Thank You,
-plh


--
I keep hitting "Esc" -- but I'm still here!