{"id":391,"date":"2020-05-27T20:40:09","date_gmt":"2020-05-27T23:40:09","guid":{"rendered":"http:\/\/maxdesign3d.com.br\/?p=391"},"modified":"2024-01-04T19:57:41","modified_gmt":"2024-01-04T22:57:41","slug":"api-vba-editando-cotas-atraves-do-formulario-userform","status":"publish","type":"post","link":"https:\/\/maxdesign3d.com.br\/en\/api-vba-editando-cotas-atraves-do-formulario-userform\/","title":{"rendered":"API VBA &#8211; Editando cotas atrav\u00e9s do formul\u00e1rio (UserForm)"},"content":{"rendered":"<h2 class=\"wp-block-heading\">Aprendendo VBA com exemplos &#8211; Aula1<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Ol\u00e1 amigos!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Para quem ainda n\u00e3o faz parte do nosso grupo no whatsapp, n\u00e3o sabe o que est\u00e1 perdendo. \u00c9 um canal para todos os profissionais da engenharia e at\u00e9 mesmo entusiastas, ningu\u00e9m ficar\u00e1 de fora. Ao final deste post deixarei um link para ingressar no grupo.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Este artigo foi motivado por uma s\u00e9rie de perguntas do pessoal do grupo Whatsapp, ent\u00e3o decidi criar uma macro exemplo e com o c\u00f3digo aberto, claro que estamos tratando de algo bem b\u00e1sico. Mas o b\u00e1sico pode ser o seu ponta p\u00e9 inicial.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"986\" height=\"785\" src=\"http:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-001.jpg\" alt=\"\" class=\"wp-image-392\" srcset=\"https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-001.jpg 986w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-001-600x478.jpg 600w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-001-300x239.jpg 300w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-001-768x611.jpg 768w\" sizes=\"auto, (max-width: 986px) 100vw, 986px\" \/><figcaption class=\"wp-element-caption\">MaxDesign3D &#8211; vba<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Para voc\u00ea que est\u00e1 inciando, ser\u00e1 um material muito v\u00e1lido.  Ent\u00e3o vamos, Como usar este material?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primeiramente, voc\u00ea precisar\u00e1 abrir a pe\u00e7a exemplo que voc\u00ea baixou. Se a pe\u00e7a n\u00e3o estiver aberta, o SolidWorks retornar\u00e1 um erro, pois a programa\u00e7\u00e3o busca e seleciona as cotas da pe\u00e7a, algo que n\u00e3o acontecer\u00e1 se a mesma estiver fechada.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vamos ao passo a passo:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Abrir a pe\u00e7a &#8220;barra redonda.SLDPRT&#8221;<\/li>\n\n\n\n<li><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Executar a macro (habilitar no seu caso n\u00e3o tenha essa barra):<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1002\" height=\"904\" src=\"http:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-002.jpg\" alt=\"\" class=\"wp-image-393\" srcset=\"https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-002.jpg 1002w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-002-600x541.jpg 600w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-002-300x271.jpg 300w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-002-768x693.jpg 768w\" sizes=\"auto, (max-width: 1002px) 100vw, 1002px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Utilizar o formul\u00e1rio ao gosto do cliente, fa\u00e7am teste, a curiosidade o levar\u00e1 a patamares maiores. <\/li>\n\n\n\n<li><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"454\" height=\"294\" src=\"http:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-004.jpg\" alt=\"\" class=\"wp-image-394\" srcset=\"https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-004.jpg 454w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-004-350x227.jpg 350w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/05\/MK-004-300x194.jpg 300w\" sizes=\"auto, (max-width: 454px) 100vw, 454px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">AS funcionalidades encontradas neste formul\u00e1rio s\u00e3o:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Inserir medidas coletadas por uma TextBox (Bot\u00e3o Inserir)<\/li>\n\n\n\n<li>Limpar informa\u00e7\u00f5es de uma TextBox (Bot\u00e3o limpar)<\/li>\n\n\n\n<li>Fechar Formul\u00e1rio(UserForm) (Bot\u00e3o fechar)<\/li>\n\n\n\n<li>Envio de Mensagem para o usu\u00e1rio ao completar a opera\u00e7\u00e3o<\/li>\n\n\n\n<li>Recostru\u00e7\u00e3o da Pe\u00e7a Automaticamente<\/li>\n\n\n\n<li>Zoom Fit  (o zoom \u00e9 regulado conforme o tamanho da pe\u00e7a)<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\">O download deste material voc\u00ea encontra logo abaixo<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><a href=\"https:\/\/mega.nz\/file\/71dlwSrI#22sPjCz4KZRNDwLVRCf910KEF7EcOMI_Vx9z9zH_O4w\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"148\" src=\"http:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2019\/03\/botao-download.png\" alt=\"\" class=\"wp-image-210\" style=\"width:296px;height:110px\" srcset=\"https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2019\/03\/botao-download.png 400w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2019\/03\/botao-download-350x130.png 350w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2019\/03\/botao-download-300x111.png 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p class=\"has-text-align-center wp-block-paragraph\">Espero que seja de grande valia este material! <\/p>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\">Eai, t\u00e1 afim de participar do nosso grupo? venha compartilhar seu conhecimento e interagir com o pessoal no bot\u00e3o abaixo.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><a href=\"https:\/\/chat.whatsapp.com\/FwYQMeQmcnS8qCI5HJxvbd\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"538\" src=\"http:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/04\/grupo-zap-1024x538.png\" alt=\"\" class=\"wp-image-364\" style=\"width:299px;height:155px\" srcset=\"https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/04\/grupo-zap-1024x538.png 1024w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/04\/grupo-zap-600x315.png 600w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/04\/grupo-zap-300x158.png 300w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/04\/grupo-zap-768x403.png 768w, https:\/\/maxdesign3d.com.br\/wp-content\/uploads\/2020\/04\/grupo-zap.png 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p class=\"has-text-align-center wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>Aprendendo VBA com exemplos &#8211; Aula1 Ol\u00e1 amigos! Para quem ainda n\u00e3o faz parte do nosso grupo no whatsapp, n\u00e3o&#8230;<\/p>","protected":false},"author":2,"featured_media":392,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,56],"tags":[],"class_list":["post-391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-downloads","category-api"],"_links":{"self":[{"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/posts\/391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/comments?post=391"}],"version-history":[{"count":3,"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/posts\/391\/revisions"}],"predecessor-version":[{"id":2029,"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/posts\/391\/revisions\/2029"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/media\/392"}],"wp:attachment":[{"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/media?parent=391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/categories?post=391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maxdesign3d.com.br\/en\/wp-json\/wp\/v2\/tags?post=391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}