+ Reply to Thread
Results 1 to 3 of 3

Inserir Imagem dentro de uma Forma

  1. #1
    Registered User
    Join Date
    04-19-2020
    Location
    Brasil
    MS-Off Ver
    2016
    Posts
    3

    Inserir Imagem dentro de uma Forma

    Boa Tarde,
    Alguém pode me ajudar com uma VBA para inserir imagem dentro de uma Forma Excel?
    Tenho uma VBA mais ela insere dentro de uma célula.

    Código:

    Sub Imagem_Foto_01A()
    Dim sPathFigura As String
    Dim sNomeFig As String
    Dim sArrayRange
    Dim sRgAddPic As Range
    Dim sValor
    Dim I As Integer
    Dim arqAAbrir
    Dim Msg, Style, Title, Response, MyString
    Msg = “Deseja realmente limpar o formulário?” ’ Define a mensagem.
    Style = vbYesNo + vbCritical + vbDefaultButton1 ’ Define o botão NÃO como padrão.
    Title = “LIMPAR FORMULARIO” ’ Define o título.
    Response = MsgBox(Msg, Style, Title)
    If Response = vbYes Then ’ O usuário escolheu Sim.
    ’ Executa alguma ação
    'Abre a caixa para selecionar e pegar o Endereço (Caminho) onde estão as figuras
    sPathFigura = Application.GetOpenFilename(“Arquivos de imagens (.jpg;.jpeg;.png;.bmp, .jpg;.jpeg;.png;.bmp”)
    ’ sPathFigura = Application.GetOpenFilename(“Arquivos de imagens (.jpg;.jpeg), .jpg;.jpeg”)
    'Definimos o Range Nomeado onde será inserido a Imagem
    Set sRgAddPic = ActiveSheet.Range(“Foto_01A”)
    Application.ScreenUpdating = False

    'Chamamos a função para inserção da figura
    AddPicOverCell sPathFigura, sRgAddPic
    Else ’ O usuário escolheu Não.

    Exit Sub
    End If

    Call Formatar_Imagens

    End Sub

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,864

    Re: Inserir Imagem dentro de uma Forma

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    04-19-2020
    Location
    Brasil
    MS-Off Ver
    2016
    Posts
    3

    Re: Inserir Imagem dentro de uma Forma

    Desculpa ter colocados fora dos padrões do forum.
    Segue planilha em anexo para me ajudarem a solucionar o problema.
    Gostaria que quando executar a VBA inserir uma imagem em uma forma.
    Obrigado


    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional forma-tin help
    By viola in forum Excel General
    Replies: 9
    Last Post: 08-05-2015, 10:40 AM
  2. Click en un link dentro de una página web
    By ballumbrosio in forum Non English Excel
    Replies: 4
    Last Post: 06-08-2015, 10:34 AM
  3. Copying Data forma website
    By gunny1979 in forum Excel General
    Replies: 0
    Last Post: 04-18-2006, 09:06 AM
  4. [SOLVED] How to convert the dates from the YY:DD forma to MM/dd/YYYY format
    By Sam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. [SOLVED] How to convert the dates from the YY:DD forma to MM/dd/YYYY format
    By Sam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. Pro Forma Taxes
    By TXdore in forum Excel General
    Replies: 0
    Last Post: 06-16-2005, 05:34 PM
  7. pro forma
    By Aysendak in forum Excel General
    Replies: 2
    Last Post: 02-11-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1