LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 345
Default User Defined Record Compile Error

Hi All,
I'm a little spooked. Getting a compiler error that uDrwRec is not defined
in the function statement.

The Public Type statement is as shown, in a module before the function.
I've moved it about..... no help. (I have not shown some variables to make
a shorter list here.)

Playing around, in the same function I typed: Dim TestRec as
and got the dropdown box showing uDrwRec and selected it.

In the next line I typed: TestRec. BUT DID NOT GET A VARIABLE LIST???

I'm building an Addin, error was not there yesterday, I use Rob Bovey's code
cleaner every day on the addin.

I'll be happy to supply any other info you might need.

Help !
Thanks, neal z.


Public Type uDrwRec ' I've also not shown comments to the right of each var.
ACN As String
DlvCd As String
Draw As Integer
iSubscr As Integer
iTStopAy(RMTStopQty) As Integer ' RMTStopQty is a public constant
NaFir As String
NaLas As String
NewACN As String
End Type




Public Function ACsShowTxtF(DrwRec As uDrwRec, _
Optional iLines As Integer = 2, _
Optional bWithvbCr As Boolean = True, _
Optional bWantNaAsLasFir As Boolean = True, _
Optional PaNum As Integer = 0, _
Optional Draw As Integer = 0, _
Optional ACN As String = "", _
Optional DlvCd As String = "", _
Optional iSubscr As Integer = 0, _
Optional ByVal SubNa As String = "", _
Optional iTStopOrAy As Variant = 0, _
Optional Opn1 As Variant = "", _
Optional Opn2 As varinat = "") As Variant

'more code

end function

--
Neal Z
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Variable not Defined Compile error Paul3rd Excel Programming 15 January 5th 08 03:22 AM
Undefined User Defined Type at compile time Michel S. Excel Programming 5 March 20th 07 03:36 PM
VBAProject name compile error, not defined at compile time Matthew Dodds Excel Programming 1 December 13th 05 07:17 PM
Help: Compile error: type mismatch: array or user defined type expected lvcha.gouqizi Excel Programming 1 October 31st 05 08:20 PM
User-defined data type; Error: Only User-defined types... tiger_PRM Excel Programming 1 July 18th 04 03:32 PM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"