{"id":14170,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/id-registro\/"},"modified":"2021-02-26T08:56:54","modified_gmt":"2021-02-26T08:56:54","slug":"register-id","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/register-id\/","title":{"rendered":"ID.REGISTRO"},"content":{"rendered":"

Descripci\u00f3n general<\/h2>\n

La funci\u00f3n ID.REGISTRO en Microsoft Excel, tambi\u00e9n conocida como REGISTER.ID en sus versiones en ingl\u00e9s, es fundamental en el entorno de macros y VBA (Visual Basic for Applications). Esta funci\u00f3n se emplea para obtener el identificador \u00fanico de una funci\u00f3n personalizada que ha sido registrada previamente.<\/p>\n

Sintaxis y par\u00e1metros<\/h2>\n

La sintaxis de la funci\u00f3n es:<\/p>\n

ID.REGISTRO(nombre_func)<\/code><\/pre>\n
Par\u00e1metros:<\/strong> <\/p>\n
    \n
  • nombre_func<\/code>: Cadena de texto que determina el nombre de la funci\u00f3n cuyo ID se solicita.<\/li>\n<\/ul>\n
    Ejemplos pr\u00e1cticos<\/h2>\n
    A continuaci\u00f3n, se presentan ejemplos pr\u00e1cticos de c\u00f3mo utilizar la funci\u00f3n ID.REGISTRO en diversos escenarios.<\/p>\n
    Escenario 1: Verificaci\u00f3n de registro de una funci\u00f3n<\/h2>\n
    Supongamos que has desarrollado una funci\u00f3n personalizada en VBA llamada MiFuncionPersonalizada<\/code> y deseas verificar que est\u00e9 correctamente registrada en Excel antes de emplearla en las hojas de c\u00e1lculo.<\/p>\n
    Sub VerificarRegistro() Dim id As Variant id = Application.Run(\"ID.REGISTRO\", \"MiFuncionPersonalizada\") If IsError(id) Then MsgBox \"La funci\u00f3n no est\u00e1 registrada.\", vbCritical Else MsgBox \"ID de la funci\u00f3n: \" & id, vbInformation End If End Sub<\/code><\/pre>\n
    Este script en VBA intenta primero obtener el ID de MiFuncionPersonalizada<\/code>. Si la funci\u00f3n no est\u00e1 registrada, muestra un mensaje de error; si est\u00e1 registrada, muestra el ID.<\/p>\n
    Escenario 2: Registro condicional de funciones<\/h2>\n
    En un entorno donde diversas macros requieren funciones personalizadas, puede ser esencial registrar una funci\u00f3n solo si a\u00fan no ha sido registrada. Esto se puede gestionar usando la funci\u00f3n ID.REGISTRO para comprobar si la funci\u00f3n ya existe.<\/p>\n
    Sub RegistrarSiNecesario() Dim id As Variant id = Application.Run(\"ID.REGISTRO\", \"MiFuncionNueva\") If IsError(id) Then Application.MacroOptions Macro=\"MiFuncionNueva\", Description=\"Esta es mi nueva funci\u00f3n personalizada\" MsgBox \"Funci\u00f3n registrada con \u00e9xito.\", vbInformation Else MsgBox \"La funci\u00f3n ya est\u00e1 registrada. ID: \" & id, vbInformation End If End Sub<\/code><\/pre>\n
    Este c\u00f3digo primero verifica si MiFuncionNueva<\/code> est\u00e1 registrada. Si no, la registra y notifica su \u00e9xito. Si ya est\u00e1 registrada, simplemente informa el ID existente.<\/p>\n
    Limitaciones y consideraciones<\/h2>\n
    Es clave mencionar que la funci\u00f3n ID.REGISTRO es especialmente \u00fatil para desarrolladores que trabajan con Excel VBA. Los usuarios que no utilizan estas herramientas generalmente no necesitan emplear esta funci\u00f3n. Adem\u00e1s, cabe destacar que no est\u00e1 disponible en Google Sheets ni en otras plataformas de hojas de c\u00e1lculo que no admiten VBA.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el n\u00famero de identificaci\u00f3n del registro de la biblioteca de v\u00ednculos din\u00e1micos (DLL) especificada o del recurso de c\u00f3digo previamente registrado<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[543],"tags":[],"class_list":["post-14170","post","type-post","status-publish","format-standard","hentry","category-complementos-y-automatizacion"],"acf":[],"yoast_head":"\nFunci\u00f3n REGISTER.ID (ID.REGISTRO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n REGISTER.ID (ID.REGISTRO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/register-id\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n REGISTER.ID (ID.REGISTRO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n REGISTER.ID (ID.REGISTRO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/register-id\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:56:54+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n REGISTER.ID (ID.REGISTRO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/register-id\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/register-id\/\",\"name\":\"Funci\u00f3n REGISTER.ID (ID.REGISTRO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:56:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n REGISTER.ID (ID.REGISTRO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/register-id\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/register-id\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/register-id\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Complementos y automatizaci\u00f3n\",\"item\":\"https:\/\/functiontranslator.com\/es\/complementos-y-automatizacion\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ID.REGISTRO\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n REGISTER.ID (ID.REGISTRO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n REGISTER.ID (ID.REGISTRO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/es\/register-id\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n REGISTER.ID (ID.REGISTRO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n REGISTER.ID (ID.REGISTRO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/register-id\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:56:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n REGISTER.ID (ID.REGISTRO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/register-id\/","url":"https:\/\/functiontranslator.com\/es\/register-id\/","name":"Funci\u00f3n REGISTER.ID (ID.REGISTRO) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:56:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n REGISTER.ID (ID.REGISTRO) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/register-id\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/register-id\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/register-id\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Complementos y automatizaci\u00f3n","item":"https:\/\/functiontranslator.com\/es\/complementos-y-automatizacion\/"},{"@type":"ListItem","position":3,"name":"ID.REGISTRO"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14170"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14170\/revisions"}],"predecessor-version":[{"id":30261,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14170\/revisions\/30261"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}