Show Picture Based On Cell
I have folder with 5 photos on c (c:Pictures). Photos are named a, b, c, d, and e. In Excel workbook sheet1 (c:Photos.xls), how to display the photos in cell range (B1:F10) in response to change in cell A1 (i.e., when A1 cell value is “a”, the photo “a” is displayed in the range B1:F10, and so on when the A1 value changes)
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Picture Based On A Value In A Cell
I have found a few solutions here in the message boards but I don't see one that totally matches what I need. Basically I want it to look up the clients logos. We only have a few clients but when sending the report to a client we don't want them to be able to see or find who our other clients are or their logos. So I need it to display a picture based on a value but to also have the pictures on a seperate sheet that I can delete before distributing. A variation of this would work but this stores all the pics on the report sheet and just hides the non active ones. [url]
View Replies!
View Related
Make A Drop Down List Show The Picture
I am trying to do, is make a drop down list show the picture above it. I have tried to change everything, and I am sure I am just a hair away from getting it right. I got the spreadsheet to where it will pull up the "Picture #" in the appropriate box, and even had it delete/hide all my pictures (I say delete/hide because I couldn't get them back after I removed the coding I was working on). Another nice function I would like would be a button, around cell B74, to erase all the picks and reset the sheet for the next season... it would have to have a prompt to verify the user was absolutely sure they wanted to do that though! But I don't know where to begin on that button issue. Can someone point me in the right direction? The spreadsheet is too big to attch, so it's hosted at the link below. The sheets involved are NFL Survivor & PicTable. On sheet PicTable, the Names & Pic #'s have already been named PicTable for ease of coding.
View Replies!
View Related
Marco To Show Picture When Cursor Point To Item
I need help on how to do this. I have a list of parts in cell A1 to A10 in sheet1. And I have all the parts photo in sheet2. What I want is, when I move my cursor to the name of the part in sheet1, say is .. A1, then the A1 photo from Sheet2 will show up at a defined cell so that I know how the parts look like.
View Replies!
View Related
Show Sheets Based On Cell Value
I have 15 sheets - Resident 1, Resident 2 etc If cell A1 on Summary tab contains 10, I want sheets Resident 1 to Resident 10 visible, everything over Resident 10 to be invisible If cell A1 on Summary tab contains 5, I want sheets Resident 1 to Resident 5 visible, everything over Resident 5 to be invisible
View Replies!
View Related
Show Different Data Based On Value Of Cell
Call centre data for financial years located in separate workbooks (1 for each year) Here's what I want to create. One main file to consolidate/view all data I've tried to make this as user friendly as possible by having a validated list, whereby the user can select the year they want to view, and hey presto, the data changes to reflect the year displayed in the validated cell.
View Replies!
View Related
Show Image Based On Cell Value
Question: I would like to have two pictures (one in cell B2, the other in cells D1-C10 to I10) display based on a data validation list that I have in A1. So, for example, if you click U.S.A., two pictures for U.S.A. show up; if you scroll down to Canada, two pictures show up. If you're interested, I have included the history of what I have tried in the past. History of what I have tried: I used this code before [url] , but that makes all pictures but 1 invisible and I need two. So then I used this one, Sub HelloWorld() 'Message box to say hello MsgBox " Sub GetPicture() Dim oPic As Picture, imgFlag As Range, imgMap As Range ' Loop Flag and Map images 'imgFlag = Worksheets("Image").Range("B1") 'imgMap = Worksheets("Image").Range("D1") For Each oPic In Worksheets("Summary").Pictures If (oPic.Name = Worksheets("Image").Range("B1").Text) Then oPic.Visible = True oPic.Top = Worksheets("Image").Range("B1").Top oPic.Left = Worksheets("Image").Range("B1").Left ElseIf (oPic.Name = Worksheets("Image").Range("D1").Text) Then oPic.Visible = True oPic.Top = Worksheets("Image").Range("D1").Top oPic.Left = Worksheets("Image").Range("D1").Left Else oPic.Visible = False End If Next oPic End Sub"
View Replies!
View Related
Hide Or Show An Image Based On A Cell Value
I have a spreadsheet with two bitmap images inserted into it. In cell E2, I will enter a number, either a 1 or a 2. if I enter a 1, I want only the first image to be visible. If I enter a 2, I only want the second image to be visible. Is there a way to accomplish this (hopefully without the need for macros)? I've attached a spreadsheet as an example of what I'm trying to do. Also, note that I'd like the images to be stacked on top of each other so that they show up in the same place regardless of wether there's a 1 or a 2 in cell E5
View Replies!
View Related
Show Numbers Based On Percentage In Cell
I have a rather large report full of data, 10+ columns contain a RANKING column, and these ranks, 1-10, are assigned by a % bracket: 1-20% = 1 21-40% = 2 41-60% = 3 61-80% = 4 81-100% = 5 101-120% = 6 121-140% = 7 141-160% = 8 161-180% = 9 181-200% = 10 There are several hundred rows in each column that all need individual ranks. My first thought is to program a if then else statement for 1 to 10 with a % limit range, but this isnt feasable as i would have to program a separate if statement for each of the many hundred rows, or do one heck of a fancy loop that i just cant contemplate (as the rows are split and sepperated... no solid uniform place for the data to be plugged.) What is the best way to go about this? I'm at a total loss of ideas with my knowledge of excel.
View Replies!
View Related
Automatically Hide / Show Rows Based On Cell Value
I wrote a small code to hide some columns if a certain cell is equal to a certain string. The cell is actually a drop down list and when they select a certain one, I want it to hide 2 columns. So I wrote the code with sub name Action, but I want it to be running all the time. I tried to achieve this by writing the following code however it gave me error 438 for my 2nd line. Sub Auto_Open() Range("A1").OnEntry = "Action" End Sub Auto Merged Post Until 24 Hrs Passes;Oh, by the way error 438 states: Object doesn't support this property or method
View Replies!
View Related
Hide & Show Rows Based On Cell Value
I have two sheets say: Sheet1 Sheet2 Sheet1 has a few comboboxes saying (YES / NO) conditions Which are assigned to particular cells (for Ex: say Combobox1 value assignes to Sheet1!B5 ) If Sheet!B5 = YES some rows in Sheet2 Say ( Row12 ,Row 15,Row 16) has to be hide. I will add a command button to sheet1 and call macro if i click command button checking the conditions in sheet1 combo boxes..rows in sheets2 has to hide..
View Replies!
View Related
Formula To Show The Value Of One Cell Based On The Value Of Another To Automate Some Internal Processes
I'm trying to get a formula to show me the value of one cell based on the value of another to automate some internal processes. Cell J3 returns today's date, then J4 says what week number that is. J5 concatenates the two to make the look up. Column A is named range "PN", and columns C onwards are named ranges to match the column heading. What I'm wanting is for the result in test cell 2 (J8), is to return the stock requirements for the current week, based on the result of cell J5. I can do this by using nested IF statements, but that would be 8 cells to calculate, then another one to find the cell that has a value. If there a way to get Excel to recognize the value in J5 as a range name, so it just needs the one formula?
View Replies!
View Related
Formula To Show A Date Range Based On The Amount Shown In Another Cell
Attached is a excel file that has a working formula for tracking cashier variances. I edited out names etc. I added a new cell called Track Back on the employee search sheet. What I want to do is only show variances for the amount of days back selected in the Track Back cell. For example if I select the last 30 days, only the last 30 days would show up below in the sheet. I am not sure if this is even possible based on the forumla that is already on the sheet. I couldn't figure out a way of doing it. But there are a lot of people on here much better with excel than me
View Replies!
View Related
Hide/Show Sheets Based On Cell Values & Validate Entry
excal VBA programming.I have attached the file name "help" for your easy explanation purpose. 1. Is it possible to hide sheet nos. 1,2,3,4 & unhide the sheet as wished by me by puting the value (1or 2 or 3 or 4) in B3 cell. 2.There are per day production rate in E18 to E22 cell. Now whenever I will give value in H18 or H19 or H20 or H21 or H22, it will check whether the value is same with the respective E 18 or E19 or E20 or E21 or E22 cell. If both the values are not equal then give a message box "WARNING!!! YOUR VALUE IS NOT SAME". Can it be possible by creating VBA programming.
View Replies!
View Related
Inserted A Listbox And Based On The Value Selected A Picture Should Be Poped
I have inserted a listbox and based on the value selected a picture should be poped. I have searched the forum and got the code below. But it is throwing an error message "object required" Private Sub ListBox1_Change() If ListBox1.Value = "x" Then Pictures("Picture 1").Visible = True Else Pictures("Picture 1").Visible = False End If End Sub Then i modified it to Sub ListBox1_Change() If listbox1.Value = "1" Then activesheets.Shapes("Picture 1").Visible = True Else activesheets.Shapes("Picture 1").Visible = False End If End Sub
View Replies!
View Related
Use Picture Name From A Cell
I have recorded a macro for inserting, sizing and positioning a product photo into a report. The photo file is in a directory containing many files. Filenames are alpha numeric codes with a .jpg extensions. I wish to be able to enter a different code into a spreadsheet cell which will be named and let the macro insert the proper photo from the files in the subdirectory. Here is the code which was recorded and which brings up the photo for file "HGGA134.jpg ". Range("B10").Select ActiveSheet.Pictures.Insert( _ "C:Documents and SettingsRichard WrightDesktopNUEVOProduct PhotosHGGA134.jpg" _ ).Select Selection.ShapeRange.LockAspectRatio = msoTrue Selection.ShapeRange.Height = 195# Selection.ShapeRange.Width = 180# Selection.ShapeRange.Rotation = 0# End Sub I need a way to change the "HGGA134" part of the code by having it reference a named cell in the report.
View Replies!
View Related
Unhide Picture If Cell Contains Value
I have attached a simplified version of the xls I am using. On the attached xls there are two tabs. The first tab (BUYS) has linked pictures of cells on the second tab (Warehousing). I would like some code which would display the pictures only when the corresponding cells in Column F have a number in it. (This number could be anything) e.g. If cell F4 has a number in it show Picture 1 If cells F4 and F5 have a number in them show Picture 1 and 2 My full xls (not attached) has another tab called SELLS. These two tabs (BUYS and SELLS) have 15 pictures each (1 for each row 4:18). Ideally an exception would be written into the code so that if the xls was named "yymmdd Asian Executions" or "yymmdd Europe Executions" none of the pictures would show up. I hope I have been clear but it's very difficult to be objective so please let me know if you need any more information.
View Replies!
View Related
Inserting A Picture Into A Cell
I am looking for a way to insert a picture into a cell BUT the picture should not float. It should change its size whenever the cells size changes - as if it was inserted into a rectangle drawn from the "PAINT" Bar. An example (but it floats) can be seen in the attached picture/
View Replies!
View Related
Changing Picture Aording To Cell Value
I've a sheet with vba code and many pictures the code's function is to display the picture which i write its name in cell (A1). it works well. the problem that the code stop to work after adding number of pictures that makes me conclude that excel has limit number of picture or pictures size or there is aproblem so i hope to find any one who can expaline this form me or solve the problem.
View Replies!
View Related
Add Picture To Cell Comment
i need to have a way to link a small picture/thumbnail to a cell. so that there is a way to preveiw it. Idealy like what happens with the comments where you hover over the cell and the comment would pop up. or failing that mabe a cell linking to the image.
View Replies!
View Related
Copy Picture Dependant On Cell
I am trying to make an Excel sheet with a frontpage sheet and a data sheet. In the data sheet I have several columns with data and then in the end a cloumn with pictures. On the front page sheet I can easily with VLOOKUP formulas transfer the desired data from the data sheet to the front page sheet but I cannot seem to figure out how to copy the picture. When I try to copy the cell with the picture in it, the formula only copies the cell value, which is "0" because the only thing which is in the cell is the picture. how to copy a given picture from one sheet to another based on the information in another cell like a "Vlookup" formula?
View Replies!
View Related
Browse For Picture File And Put Location In Cell
I am trying to code where when someone hits the command button it will popup with the browse form and they find the location of the file and it puts there choice in a cell. don't know if it matters but the location would always be a picture. Here is what I have but it shows -1 in the cell HTML Dim strFilePath As Variant strFilePath = Application.FileDialog(msoFileDialogFolderPicker).Show shUserInformation.Range("D12").Value = strFilePath
View Replies!
View Related
If A Cell Has Data Show It If Not Show 0
I have a column of data held in column B. I am required to show the following. If there is data in the cell then it is to be left. If there is no data in the cell then I would like to show the value 0. I have tried using a circular reference, using the formula =IF(ISBLANK(B1),0,B1) and other similar formulas but they dont work as the formula overwrites the data in it. do I need a macro?, or conditional formatting?
View Replies!
View Related
Flashing Cell & Picture Load Additional Code
At the moment I have two macros. One loads up a background picture into my work sheet when I start it up, the other two are called ‘StartBlinking’ and ‘StopBlinking’. This is the macro code I have to load up the picture: Sheets("CASHFLOW + FUNDSFLOW").SetBackgroundPicture Filename:= _ "G:EH_Background.JPG" What I hope to achieve is: 1. Get the picture to ONLY load up if it actually exists on the G: drive, otherwise do nothing. 2. If value 1 to 13 is input in Cell C3, run the macro StopBlinking. 3. If Cell C3 is left blank again, run the macro StartBlinking.
View Replies!
View Related
Macro To Change Linked Picture (Camera) Cell Reference
I am a complete newbie with the camera tool. Is there any way to make the camera tool dynamic so that the cells the tool is referencing can change upon the click of a button or some other form of switch? I am creating my first dashboard and this is the last step for my report to be completely dynamic. ----------------------------------------------------------------------- Never mind, I apologize i just figured this one out... Create a user defined formulaIn the UDF Create an if statementThe if statement's condition is the logistics in the shift mechanismThe value if true is the first group of cells you want in the snap shotThe value if false is the second group of cells you want in the snap shot, The range you want to toggle betweenRename the cell reference of any snap shot you have taken with the UDF name. In my example my UDF is "Dude" so when you select the camera tool it shows =Dude as the cell referenceReference a scroll bar to the conditional cell you selected in the if statement or choose statement. This is the shift mechanism If you want to toggle between more than 2 sets of data use =Choose instead of =if
View Replies!
View Related
Insert Picture & Auto Size To Active Cell Dimmensions
What I am trying to do is to give the user the ability to insert a photo and have it autosize into a range of cells--so far I can only get it to work with a single cell and a predefined file. Can this be refined so that rng references a group of cells and pic somehow lets the user input a file name or pick its name and location? Sub test() On Error Resume Next Set pic = ActiveSheet.Pictures.Insert("C: ange.gif") On Error Goto 0 If Not pic Is Nothing Then 'Found it!' Set rng = ActiveCell With pic .Height = rng.Height .Width = rng.Width .Left = rng.Left .Top = rng.Top End With End If End Sub
View Replies!
View Related
Show Worksheets Based On User
I have a workbook with multiple worksheets, and I am trying to create a title sheet where a user can select their name from a drop down list, and Excel will show only the tabs that are associated with that user. For example: The worksheets in the workbook are: Heading Control sheet Client Relations Admin Sales Summary etc... The user Hudnall needs to see the sheets: Client Relations Sales Summary The user Ferguson needs to see the sheets: Sales Summary Control Sheet I want the user to be able to select their name from a drop down list on seperate sheet, and have the Macro show only the sheets that they need to see.
View Replies!
View Related
Show Sheet Based On Weekday Name
I have 5 sheets in a workbook named the following: Monday delivery Tuesday delivery Wednesday delivery Thursday delivery Friday delivery I want a macro to fire when the workbook opens. I want it to look at what day it is and then show the sheet for the next day and hide all the rest. Example, with today being Tueday, if someone opened the workbook, I want only the Wednesday delivery sheet to be visible and all the others to be hidden, well very hidden. Then tomorrow it will show Thursday delivery and so on. If opened on a Friday, it should show the Monday delivery sheet.
View Replies!
View Related
Show Users Only Certain Data Based On Their Name
I have a large workbook that contains markbook info of all my classes that I teach. I don't want them to see all my workbook as it would be too confusing. I would like to hide all the data and have a simple INPUT box on a separate page that would ask for their name. The name would then be used to find the row number, add this to a specific column number (always the same) which hold their marks and then return the mark in a Message box.
View Replies!
View Related
Show Value From A Table On Second Sheet Based On Month
I need to display a value that is in a table on one sheet when the month is matched on the first sheet. The month that I need to match up is on sheet1 in cell B1 I have a table on sheet2 that is a year budget, the cell range for the months are C5:Y5 Under each month I have a list of headings and it is these cells that I need to display on sheet1 in the relevant box.
View Replies!
View Related
Show Room Occupancy Based On Dates
I want to a create a formula that reviews a series of start dates and end date, then sums the number of days (if the end and start date are withing a yearly period). i.e. Column A = Room No Column B = Start dates Column C = End dates Column A references a list of rooms (Room List) If Column A = Room123 If start date is equal to or greater than 31/12/2007 If end date is less than or equal to 31/12/2008 Calculate the number of days used.
View Replies!
View Related
Hide & Show Sheets Based On Names
I made one file with 13 sheets. sheet1 tab name is : MAIN and other sheet tab name like following 2. xyz-Sales 3. xyz-Rev 4. xyz-SSN 5. xyz-ddn 6. abc-Sales 7. abc-Rev 8. abc-ddn 9. abc-ssn 10. ddd-sales 11. ddd-Rev 12. ddd-ssn 13. ddd-ddn In Main sheet There are 3 buttons 1 . XYZ 2. abc 3. ddd when user press on xyz button then only xyz sheets (like sheet 2 to 5) are shows to user and other sheets are very hide if user press abc button then only abc sheets (like sheet 6 to 9) are shows to user and other sheets are very hide i don't want to use Sheet2.Visible = xlSheetVeryHidden i want to use finde xyz sheet tab name and shows and other are hide.
View Replies!
View Related
Show Data From Another Worksheet Based On Matching Properties
I'm building a spreadsheet for a sporting franchise using a pull-down validation menu. Once the opposing team name is selected from the drop down menu, I would like it to display the opposing teams players and their statistics. On the database worksheet, I have a web query pulling names and statistics from the web. Each player name has his team name in his corresponding row. What function can I use that will search for that team name and report it back to the display sheet? Once I have the player name there, I think I can figure the statistic portion... But I can't seem to figure out how to pull all of the players with the matching team name into my display sheet. Example: A1 on worksheet "A" contains a pull down menu with team names "Lightning", "Storm", "Magic", and "Thunder". A16-A20 on worksheet "B" contains players from team "Lightning" A21-A25 on worksheet "B" contains players from team "Storm" A26-A30 on worksheet "B" contains players from team "Magic" A31-A35 on worksheet "B" contains players from team "Thunder" B16-B20 on worksheet "B" contains team name "Lightning" B21-B25 on worksheet "B" contains team name "Storm" B26-B30 on worksheet "B" contains team name "Magic" B31-B35 on worksheet "B" contains team name "Thunder" If I pull down "Lightning" on A1 (worksheet "A"), I want the following to display:..........................
View Replies!
View Related
Show/Hide Command Button Based On Location
What i am trying to do is make a command button appear when you hit any cell of the row its on. For example, If you were to hit any cell on rows 1 or 2 the command button will appear and when I am not on the visible property goes back to false. I have a ton of buttons on this sheet and I am trying to clean it up so buttons only appear as needed.
View Replies!
View Related
Show Late & On Time Based On Dates
I'm working with data as displayed below. My objective is to create a table by Model with summed quantitiies in two columns representing On-Time and Late. On-Time is achieved when Date Shipped is on or before the Promised Date. I have included the required format to be achieved in the second example. I'm willing to work with macros or VBA for the solution. I just need guidance to learn how to accomplish this task. CREATE TABLES LIKE BELOW? ----B---- -----C------ --D-- ----E----- 6 Promised Date Shipped Inspection 7 Date Mod # 8 11/30/07 11/01/07 780 15216 9 10/10/07 11/01/07 230 15174 10 11/20/07 11/07/07 665 16314 11 9/13/07 11/07/07 230 15008 12 12/10/07 11/08/07 780 14452 13 11/15/07 11/08/07 780 15233 14 12/18/07 11/12/07 665 15219 15 12/3/07 11/12/07 780 15224 16 10/14/07 11/12/07 230 15011 CREATE TABLES LIKE BELOW? -N-- ---O--- -P-- 7 Mod On Time Late 8 225 9 230 10 335 11 555 12 665 13 780 14 1120
View Replies!
View Related
Show (Filter) Rows Based On Multiple Criteria
I'm trying to create a formula (used in sheet 2 column B) that would generate the results in sheet2.B based on the contents of sheet 1. sheet2.B2 would contain a formula searching for the both "Y" in sheet1.C and the text in sheet2.A2 (in this case "E&P"). When each match is found, the contents of sheet1.A should be returned to sheet2.B, as shown in the mockup. There will be multiple matches (at least 15-20) for each search criteria, and I don't know how many there will be ahead of time. I've tried various formulas, and they either have incorrect syntax and return every row in a range, or only return the first match correct match each time instead of all correct matches. I found some UDFs posted online that claim to do this, but I've gotten them into the spreadsheet and they generate # NUM errors. I would prefer to work with Excel-native formulas if possible, because I'm going to eventually hand this off to someone else to maintain and they may not have the level of expertise to deal with UDFs.
View Replies!
View Related
Hide/Show UserForms Based On Workbook And Worksheet
I'm just beginning to work with userforms and have created a couple of forms for workbook navigation. The Menu form is set to appear only on the menu worksheet and the Navbar form is set to show on several database sheets. Both forms are set th hide when the workbook is deactivated. Private Sub Workbook_Deactivate() Menufrm.Hide Navbar.Hide End Sub The problem is that when I return to the workbook the forms do not unhide. Using the workbook_activate event causes both forms to show simultaneously. I also have the worksheet_activate event set to show the applicable form. Private Sub Worksheet_Activate() Application. ScreenUpdating = False ActiveWindow.DisplayGridlines = False Navbar.Show Navbar.Left = Range("B3").Left Navbar.Top = Range("B3").Top Application.ScreenUpdating = True End Sub Upon returning to this workbook, I only want the appropriate form to show relative to the worksheet that is active. That is, if I was on sheet2 when I switched to another workbook, sheet2 would be active when I return to the workbook and should show the Navbar form. The menu form should show on sheet1, and the navbar form on sheets 2-5. How do I get the correct form to show when I re-activate the workbook?
View Replies!
View Related
Toggle To Hide & Show Rows Based On Conditions
First, I realize there are plenty of hide cells threads but I have yet to find one pertaining to my situation and I apologize in advance if I this solution has already been posted. The Problem: I am looking for macro code to a toggle button that will hide various rows that have no value between multiple sets of rows. The toggle should refresh the format of the rows as the information that was blank could later on have value. The Setup: For each set of rows, the first row will have the label T and the last will have the label S. In between T and S there can be data. If the cells between T and S are all empty then the rows including T and S should be hidden other wise only the non blank cells between T and S should be visible. The Reason: I have a master database worksheet, there are four copies of the master database worksheet each entitled phase1, ""2, ""3, & ""4 respectively. These phase sheets are linked to the master sheet and show the entire row's data based upon the beginning cell of each row showing either phase1, ""2, & so on.. The data is broken up into many sub databases and traditional auto filters or advanced auto filters will not be applicable as the title of the data and the empty rows in between need to be hidden if the data is empty.
View Replies!
View Related
Formula To Show Project Size Based On Number Of Hours
I need to show the size of a project in a cell based on it's number of hours, e.g. Between 5-80 hours = SMALL Between 80-200 hours = MEDIUM Over 200 hours = LARGE How can I do this? I can't get the IF function to work like this (unless I'm doing something wrong) and I thought about using a pivot table but think there must be an easy formula to use?
View Replies!
View Related
|
TRACKER
