{"version":"1.0","provider_name":"Saibam","provider_url":"https:\/\/saibam.com.br\/excel","author_name":"admin","author_url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/","title":"String - Saibam","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"lKGZMbqMo8\"><a href=\"https:\/\/saibam.com.br\/excel\/funcao-string-no-vba\/\">String<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/saibam.com.br\/excel\/funcao-string-no-vba\/embed\/#?secret=lKGZMbqMo8\" width=\"600\" height=\"338\" title=\"&#8220;String&#8221; &#8212; Saibam\" data-secret=\"lKGZMbqMo8\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/saibam.com.br\/excel\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"A fun\u00e7\u00e3o String em VBA \u00e9 extremamente \u00fatil para gerar strings que consistem em um \u00fanico caractere repetido v\u00e1rias vezes. \u00c9 frequentemente utilizada em formata\u00e7\u00e3o de texto, preenchimento de espa\u00e7os ou na cria\u00e7\u00e3o de padr\u00f5es de teste. Os exemplos providenciados acima demonstram a flexibilidade da fun\u00e7\u00e3o, desde a cria\u00e7\u00e3o de simples sequ\u00eancias de caracteres at\u00e9 seu uso em express\u00f5es mais complexas. A tabela fornece um resumo r\u00e1pido para refer\u00eancia futura. Aprender a utilizar a fun\u00e7\u00e3o String \u00e9 um passo importante para dominar a programa\u00e7\u00e3o em VBA"}