Which Variable to use?

[AndrewKent]

Hi there,

On my last few threads I have been asking questions about how to best declare variables. After reading through the excellent content on C Pearsons website I now have a better understanding of how to declare a variable.

What it doesn't give me however is a list of what variables to use in certain situations. For example...

Text would be As String
Number would be As Intiger
True would be As Boolean

...does anyone have a list of what variables to use and when?

Andy

 

[VoG]

This may help http://www.ozgrid.com/VBA/variables.htm

 

[AndrewKent]

Thanks, what variable should I use for this...

DeleteCode = Application.InputBox("Please enter the delete code")

 

[VoG]

That would be a String.

 

[AndrewKent]

Thanks! I'm going through and properly declaring all my variables, there are about 46,000 lines of code so expect a few questions over the next few days!

Cheers again,

Andy

 

[AndrewKent]

Okay next one...

    Set OutApp = CreateObject("Outlook.Application")
    OutApp.Session.Logon
    Set OutMail = OutApp.CreateItem(0)
        
    With OutMail
        .To = "" & DevelopmentAddress & ""
        .CC = ""
        .BCC = ""
        .Subject = "Connect: Gateway Error"
        .body = "Date: " & vbTab & vbTab & vbTab & Format(Now, "dd-mmmm-yyyy") & vbNewLine & _
        "Version Name: " & vbTab & "" & VersionName & "" & vbNewLine & _
        "Record ID: " & vbTab & vbTab & "" & RecordID & "" & vbNewLine & _
        "Connect Routine: " & vbTab & vbTab & "" & ConnectSubRoutine & ""
        .Send
    End With
    Set OutMail = Nothing
    Set OutApp = Nothing

OutMail and OutApp?

 

[RoryA]

Assuming you are late binding, declare them both as Object.

 

[VoG]

Try

Dim OutApp As Object
Dim OutMail As Object

 

[AndrewKent]

Excellent, okay next...

ActiveRow = Worksheets("Status History").Range("B" & Range("B65536").End(xlUp).Offset(1, 0).Row & "").Row

String?

 

[VoG]

Long.