Public Function GetStringVal(ByVal Hkey As HKEYRegConstants, ByVal SubKey As String, ByVal strValue As String) As String
    Dim KeyHnd As Long
    Dim datatype As Long
    Dim lResult As Long
    Dim strBuf As String
    Dim lDataBufSize As Long
    Dim lValueType As Long
    Dim intZeroPos As Integer
    r = RegOpenKey(Hkey, SubKey, KeyHnd)
    lResult = RegQueryValueEx(KeyHnd, strValue, 0&, lValueType, ByVal 0&, lDataBufSize)


    If lValueType = REG_SZ Then

        strBuf = String$(lDataBufSize, " ")
        lResult = RegQueryValueEx(KeyHnd, strValue, 0&, 0&, ByVal strBuf, lDataBufSize)

        If lResult = ERROR_SUCCESS Then
            intZeroPos = InStr(strBuf, Chr$(0))

            If intZeroPos > 0 Then
                GetStringVal = Left$(strBuf, intZeroPos - 1)
            Else
                GetStringVal = strBuf
            End If
        End If
    Else
        Err.Raise vbObjectError + 513, strValue, strValue
    End If
End Function

Option Explicit
Declare Function RegCloseKey Lib "advapi32.dll" (ByVal Hkey As Long) As Long
Declare Function RegCreateKey Lib "advapi32.dll" Alias "RegCreateKeyA" (ByVal Hkey As Long, ByVal lpSubKey As String, phkResult As Long) As Long
Declare Function RegDeleteKey Lib "advapi32.dll" Alias "RegDeleteKeyA" (ByVal Hkey As Long, ByVal lpSubKey As String) As Long
Declare Function RegDeleteValue Lib "advapi32.dll" Alias "RegDeleteValueA" (ByVal Hkey As Long, ByVal lpValueName As String) As Long
Declare Function RegOpenKey Lib "advapi32.dll" Alias "RegOpenKeyA" (ByVal Hkey As Long, ByVal lpSubKey As String, phkResult As Long) As Long
'FIXIT: As Any is not supported in Visual Basic .NET. Use a specific type.                 FixIT90210ae-R5608-H1984
Declare Function RegQueryValueEx Lib "advapi32.dll" Alias "RegQueryValueExA" (ByVal Hkey As Long, ByVal lpValueName As String, ByVal lpReserved As Long, lpType As Long, lpData As Any, lpcbData As Long) As Long
'FIXIT: As Any is not supported in Visual Basic .NET. Use a specific type.                 FixIT90210ae-R5608-H1984
Declare Function RegSetValueEx Lib "advapi32.dll" Alias "RegSetValueExA" (ByVal Hkey As Long, ByVal lpValueName As String, ByVal Reserved As Long, ByVal dwType As Long, lpData As Any, ByVal cbData As Long) As Long

Public Enum HKEYRegConstants
    HKEY_CLASSES_ROOT = &H80000000
    HKEY_CURRENT_USER = &H80000001
    HKEY_LOCAL_MACHINE = &H80000002
    HKEY_USERS = &H80000003
    HKEY_PERFORMANCE_DATA = &H80000004
End Enum

Public Const ERROR_SUCCESS = 0&
Public Const REG_SZ = 1
Public Const REG_DWORD = 4

Public r As Long


Public Sub CreateKey(ByVal Hkey As HKEYRegConstants, ByVal SubKey As String)
    Dim KeyHnd&
    r = RegCreateKey(Hkey, SubKey, KeyHnd&)
    r = RegCloseKey(KeyHnd&)
End Sub



Public Function GetStringVal(ByVal Hkey As HKEYRegConstants, ByVal SubKey As String, ByVal strValue As String) As String
    Dim KeyHnd As Long
    Dim datatype As Long
    Dim lResult As Long
    Dim strBuf As String
    Dim lDataBufSize As Long
    Dim lValueType As Long
    Dim intZeroPos As Integer
    r = RegOpenKey(Hkey, SubKey, KeyHnd)
    lResult = RegQueryValueEx(KeyHnd, strValue, 0&, lValueType, ByVal 0&, lDataBufSize)


    If lValueType = REG_SZ Then

        strBuf = String$(lDataBufSize, " ")
        lResult = RegQueryValueEx(KeyHnd, strValue, 0&, 0&, ByVal strBuf, lDataBufSize)

        If lResult = ERROR_SUCCESS Then
            intZeroPos = InStr(strBuf, Chr$(0))

            If intZeroPos > 0 Then
                GetStringVal = Left$(strBuf, intZeroPos - 1)
            Else
                GetStringVal = strBuf
            End If
        End If
    Else
        Err.Raise vbObjectError + 513, strValue, strValue
    End If
End Function


Public Sub SaveStringVal(ByVal Hkey As HKEYRegConstants, ByVal SubKey As String, ByVal SubString As String, ByVal Value As String)
   
    Dim KeyHnd As Long
    Dim r As Long
    r = RegCreateKey(Hkey, SubKey, KeyHnd)
    r = RegSetValueEx(KeyHnd, SubString, 0, REG_SZ, ByVal Value, Len(Value))
    r = RegCloseKey(KeyHnd)
End Sub


Function GetDwordVal(ByVal Hkey As HKEYRegConstants, ByVal SubKey As String, ByVal strValueName As String) As Long
   
    Dim lResult As Long
    Dim lValueType As Long
    Dim lBuf As Long
    Dim lDataBufSize As Long
    Dim r As Long
    Dim KeyHnd As Long
    r = RegOpenKey(Hkey, SubKey, KeyHnd)
    lDataBufSize = 4
    lResult = RegQueryValueEx(KeyHnd, strValueName, 0&, lValueType, lBuf, lDataBufSize)


    If lResult = ERROR_SUCCESS Then
        If lValueType = REG_DWORD Then
            GetDwordVal = lBuf
        End If
       
    End If
    r = RegCloseKey(KeyHnd)
End Function



Function SaveDwordVal(ByVal Hkey As HKEYRegConstants, ByVal SubKey As String, ByVal strValueName As String, ByVal lData As Long) As Long
   
    Dim lResult As Long
    Dim KeyHnd As Long
    Dim r As Long
    r = RegCreateKey(Hkey, SubKey, KeyHnd)
    lResult = RegSetValueEx(KeyHnd, strValueName, 0&, REG_DWORD, lData, 4)
   
    r = RegCloseKey(KeyHnd)
End Function


Public Function DeleteKey(ByVal Hkey As HKEYRegConstants, ByVal strKey As String) As Long
   
        r = RegDeleteKey(Hkey, strKey)
End Function


Public Function DeleteValue(ByVal Hkey As HKEYRegConstants, ByVal SubKey As String, ByVal strValue As String) As Long
   
    Dim KeyHnd As Long
    r = RegOpenKey(Hkey, SubKey, KeyHnd)
    r = RegDeleteValue(KeyHnd, strValue)
    r = RegCloseKey(KeyHnd)
End Function

hola tengo un module que no me acuerdo de donde me lo descargue . pero cuando intento yamar a esta funcion   me da argumento no opcional

public function sumar(byval num1 as integer,byval num2 as integer,optional byval num3 as integer) as integer
     'Se requiere que metas el valor de la variable Num1 y de Num2 sIEMPRE NUMERICOS DE TIPO ENTERO 'Integer'
     'NUM3 es opcionla y puede o no ser asignado un 'X' Numero
     suma=num1+num2+num3
end function
 

     dim res as integer
     res= sumar(10,10)
     msgbox res
 

     dim res as integer
     res=sumar(10+10+12)
     msgbox res
 

public function sumar(byval num1 as integer,byval num2 as integer,optional byval num3 as integer=999) as integer
     'Se requiere que metas el valor de la variable Num1 y de Num2 sIEMPRE NUMERICOS DE TIPO ENTERO 'Integer'
     'NUM3 es opcionla y puede o no ser asignado un 'X' Numero
     suma=num1+num2+num3
end function
 

dim res=sumar(10,10)
msgbox res 'Da como resultado 1019 por el valor de Num3 q se tomo el valor por default