picture

I'm looking for a formula in cell D1 and down, that will add 1 or 2 "0" in front of the ( digit or number ) that when I "concatenate" them together from cell A1 with B1 see picture or is there another solution ? Thank you

Hello everyone, i tried to search and find what I am looking for but with no success probably because I cannot describe it very well. I will try to explain what I need with a picture. Thanks for your assistance in advance.

I want to delete picture based on cell value If Target.Value = "Yes" Then delete RedArrow picture should only show GreenArrow picture not both If Target.Value = "No" Then delete GreenArrow picture should only show RedArrow picture not both<strike></strike> Private Sub Worksheet_Change(ByVal...

Hello hope everyone is doing great! So I am trying to copy and paste these pictures with specific "names" onto specific slide onto an existing PowerPoint. Below is the code that I am currently using please let me know if I can expound in anyway. I keep getting an error message on the bold, red...

I am trying to rename a picture that I just pasted (a copied screenshot) so that way I can consistently copy and paste and modify using the same name. So far the code I have is this: Application.SendKeys "({1068})", True DoEvents Dim PicName As Variant PicName = "Cinco Bug All Screenshot1"...

I am looking to find out how to add code to my VBA script for when a picture button is clicked I have a series of picture buttons which, if I click any one of them runs through a script to confirm or deny access What I now need to do is: If the access is granted to the picture button clicked...

Hello, I am trying to insert a picture such that it spans the width and high of range G4:G8, which is about 1.13 in by 1.2 in according to the format graphic size & properties. Unfortunately, my picture continues to be inserted in range E4:E8 and *I DONT KNOW WHY* :mad::mad::mad::mad: This is...

Hi, I Would like to add picture as a background of cell comment, When i click on the cell comment should be show with the background picture, Does anyone know how to can do it? Regards!

Hello everyone, I would like to make a table in excel, First three columns will be include only text or numbers but in next two columns i want to insert a pictures (one column) and very long sentence/string (last column), when i click on cell in these column/s the picture or long text string...

i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them Exemple like in the picture

Hello Kings of excel i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them Exemple like in the picture

Here is my code !! In my code, there is no error but doesn't effect, I dont know why ? Appreciate for any idea. Sub InsertPicture(PictureFileName As String, TargetCell As Range, _ CenterH As Boolean, CenterV As Boolean) ' inserts a picture at the top left position of TargetCell ' the...

Are you able to place comboboxes over an image? I have an image resembling a trailer and I want comboboxes to be on top of it looking like the selection within the combobox is a certain pallet in that location of the trailer. Possible? I've tried dragging the comboboxes onto the picture and...

Hi Everyone, I have used "picture link" to paste the data(in sheet2) from my worksheet(sheet1) And I resize that picture to bigger. After that I copy sheet2 to sheet3, sheet4 and sheet5. The picture'size (from "picture link") is equal size of worksheet(sheet1) How can I resize "picture...

Is there any way to have Navigation buttons (like Access record selectors) on an Excel Form? I have a Form displaying pictures.. and would like to enable Next-Previous-End. Because the picture uses the whole Form (and can be dragged smaller/larger) extra controls on the Form aren't ideal as I...

Hi, I'd like to know two things... One: Is there a way I can add something in a userform (button, textbox, etc.) where I can upload a picture from a shared folder? Once you hit submit to transpose the information on the sheet it will show either the picture or a link to open up that photo...

I forgot which property of the textbox makes the corner like a "hook" to be able to resize it to the user's discretion. Here is a picture of what I mean: Anyone know? Thanks for your help.

Conditional formatting is great for making a separate cell display when another cell has data, can this be done with a picture ? So if an adjacent cell contains 1 or more a very small picture displays however if the cell is 0 then no picture visible ?

Hi. I have searched around the forum and tried to apply various functions to my range, but I can't seem to get it to work. Problem: Average of values in a range of cells containing both strings and values. See picture. https://ibb.co/KrCCBZB Question: What is wrong with my formula? Thanks...

Hi All, I'm using the below code to send a range of cells using a command button click, which works as expected, but misses out a picture that I would also like to send: Sub SendSelectedCells_inOutlookEmail() Dim objSelection As Excel.Range Dim objTempWorkbook As Excel.Workbook Dim...