https://community.intel.com/t5/Intel-Fortran-Compiler/Visual-Fortran-DLL-for-Visual-Basic/m-p/840750#M58719 i read that the Complex data type can be handled in C with a user-defined data type. can one do the same in VB? in the mixed programming language guide it didn't have that entry for VB, however, there is user-defined data type as well in VB, no? would it also work if one is to define like in C? Mon, 09 Sep 2002 10:37:11 GMT deeptii 2002-09-09T10:37:11Z https://community.intel.com/t5/Intel-Fortran-Compiler/Visual-Fortran-DLL-for-Visual-Basic/m-p/840749#M58718 hi! i am converting some math fortran codes into dlls so i can use them in VB and Excel. however, i don't know what data type to use in VB to match VF's "Complex" datatype. also, i don't know what to put for declaration like "double precision dx(*)" into data type in VB. can someone please give me some light here~<BR /><BR />thanks! Mon, 09 Sep 2002 10:15:54 GMT https://community.intel.com/t5/Intel-Fortran-Compiler/Visual-Fortran-DLL-for-Visual-Basic/m-p/840749#M58718 deeptii 2002-09-09T10:15:54Z https://community.intel.com/t5/Intel-Fortran-Compiler/Visual-Fortran-DLL-for-Visual-Basic/m-p/840750#M58719 i read that the Complex data type can be handled in C with a user-defined data type. can one do the same in VB? in the mixed programming language guide it didn't have that entry for VB, however, there is user-defined data type as well in VB, no? would it also work if one is to define like in C? Mon, 09 Sep 2002 10:37:11 GMT https://community.intel.com/t5/Intel-Fortran-Compiler/Visual-Fortran-DLL-for-Visual-Basic/m-p/840750#M58719 deeptii 2002-09-09T10:37:11Z https://community.intel.com/t5/Intel-Fortran-Compiler/Visual-Fortran-DLL-for-Visual-Basic/m-p/840751#M58720 The equivalent of Fortran's DOUBLE PRECISION data type in Excel VBA is Double, but I can't recall seeing a declaration of DOUBLE PRECISION var_name(*) in Fortran as you mention below. Pass VBA_dble_var(1) from VBA to Fortran. VBA's default passing mechanism is by reference, so it matches up with Fortran's.<BR /><BR />Mike Mon, 09 Sep 2002 19:03:24 GMT https://community.intel.com/t5/Intel-Fortran-Compiler/Visual-Fortran-DLL-for-Visual-Basic/m-p/840751#M58720 durisinm 2002-09-09T19:03:24Z https://community.intel.com/t5/Intel-Fortran-Compiler/Visual-Fortran-DLL-for-Visual-Basic/m-p/840752#M58721 It's not as easy as it first looks to implement complex in VB via a UDT. You could try, at some price, VBMatrix libtary from Matlab.<BR /><BR />HTH,<BR />Gerry T. Mon, 09 Sep 2002 21:25:39 GMT https://community.intel.com/t5/Intel-Fortran-Compiler/Visual-Fortran-DLL-for-Visual-Basic/m-p/840752#M58721 gfthomas8 2002-09-09T21:25:39Z