Picture When Combo Box Is Changed
Jun 28, 2009
This is the first VBA project i've done on Excel, and its not very big. I've never done any programming before, but i need help on this
What i'm trying to do it to have the Combo box that when an item is selected the respective picture shows next to it (i've got a seperate sheet with the products, prices, pics etc...)
After trying everything to get the picture to show, i switched to VBA because it looked like i could do it in that. The first thing i did was record a macro for each picture - the first one goes like this (its called TEST)
View 10 Replies
ADVERTISEMENT
Sep 19, 2009
I want to make a combo box in excel that, if i select it the sheet inside the combo box will appear.
Example:
Inside of combox are: Sheet1
Sheet2
Sheet3
If i click combo box and i choose sheet3 the sheet3 will appear.
How can i do this? theirs a macro code to use?
View 9 Replies
View Related
Mar 19, 2012
In Excel 2010, is there any way to paste a picture into a small picture/diagram box, and upon double clicking the picture it would explode to a larger size? And I guess double clicking it again would make it return to its original (smaller) size. I would be pasting several pictures into several different picture/diagram boxes and would need this to be a relative reference so that upon selection it explodes the appropriate picture?
View 1 Replies
View Related
Nov 18, 2007
I want to have a sample file in excel which store picture of student in comment, I did this, but when I want to insert picture the file dialog appears, and if I click cancel, then there is an error, why? If some one optimise the code it would be very nice
View 6 Replies
View Related
Oct 9, 2008
The first combo box is on a userform so that a subject can be selected
View 3 Replies
View Related
Jun 18, 2014
I have done the above where when I select a picture name from a drop down list it displays the relevant picture in another cell by using the IF function in the named formula
My question is why cant I use VLOOKUP instead of IF in the named formula. When I use it it comes with an error.
View 6 Replies
View Related
Jan 22, 2009
i have saved some pictures in my excel sheet.
in the next sheet i want that when i write the picture name the picture will appear as vlookup helps in the getting text and nos. can i do this with pictures or i tried to get to much from excel.
View 10 Replies
View Related
Mar 17, 2009
I am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB
why is this disproportionate growth happening and is there a way around it - I dont want my Price List growing too large but need the images....?
View 9 Replies
View Related
Oct 19, 2008
I have to create two combo boxes and when a user selects a value from one combo box, the values should get changed in the other combo box.
For example : if one combo box has values like "c/c++ programming" "java programming" and so on.. ... i would like to display the authors recommended (corresponding to combo box1) in the combo box 2.
View 6 Replies
View Related
Mar 23, 2014
I want to paste/show a photo in a particular cell (D2) on a worksheet (called PP). I wish to delete any photo that may already be there in D2.
The picture's name (e.g. J-145.jpg) will be found in another sheet (called MP) in cell H1.
My pictures are stored in a folder (lets call it c:pictures) and the one I want has the same name (J-145.jpg).
I've tried many macros but none work.
View 14 Replies
View Related
Feb 1, 2007
I would like to create a combo box however the contents of the combo box depends on what i have selected in a previous combo box.
View 2 Replies
View Related
Dec 6, 2007
i m working on a mechanical project , I need to do some modifications to my XLS file that i aint familair with.
http://aycu36.webshots.com/image/348...0572870_rs.jpg
View 10 Replies
View Related
Apr 24, 2007
I have a forecast spreadsheet with 10 data tabs and a summary tab.
On the summary tab, cell R131 contains the year end profit figure.
What I would like to do, is whenever this value changes and I am in a different tab, a small pop up appears in the current tab telling me what the R131 value has changed by. eg "Profit up £1000"
At the moment I keep having to go back to the summary tab to see the effects of changes across the whole spreadsheet.
View 9 Replies
View Related
Dec 30, 2009
If the value of any cell in in column D is changed to "Closed", a message box will appear that says "Others must be notified when item is closed". In that message box, I want two buttons: Button 1 One is cancel and will undo the change. Button 2 will open MS Outlook with pre-filled email addresses and will attach the open worksheet. After the email is sent, to return to Excel.
View 4 Replies
View Related
Jan 1, 2010
when the name changed and sum changed.
View 9 Replies
View Related
Oct 2, 2008
I have created a userform with multi pages... One of the page is up and running ok.
However I have on one page entries like customer number, name, address, and so on.
I have the same userform from a book which I like to use in one of my pages.
Now what I have problems with is that I need one page to refer to another worksheet of the workbook.
Lets say first page to one worksheet the second page to another. And so on.
Here is the code from the book and it likes to refer to the same worksheet as the userform is opening up.
Private Sub frmDFG_Initialize()
'Startzeile für das Drehfeld festlegen
If .ActiveCell.Row < 3 Then
spn_Change = 3
Else
spn_Change = ActiveCell.Row
End If
End Sub
View 9 Replies
View Related
Jul 26, 2007
I have the following code on my worksheet.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B2")) Is Nothing Then
Do_it
End If
End Sub
Cell B2 contains an employee number. What I need to do is save some data for the employee number that was in cell B2 just before it was changed.
Example: If employee number "10" is entered in B2.
Then the user were to change the employee number in cell B2 to "55" I would like to use the previous value "10" to do some VBA stuff with.
View 5 Replies
View Related
Oct 30, 2008
Excel has went from using the backslash to using a hyphen. If I try to format the cell, all the date choices use the hyphen, what possibly changed?
View 3 Replies
View Related
Jul 24, 2009
Is it possible to save a workbook whenever any changes are made to any cell in a specific column? The reason - I'm putting an excel workbook out on a network drive for 4-5people to share. The sheet contains work items which are imported every 4 hours... Column A contains the status.
I want to save the file every time anybody changes a status to prevent multiple users from working on the same item. I realize that I could build a form then load each workitem into the form, then apply the save to a change event on the field/control, but that's something for next week - I need to get this out the door, bare bones, as soon as possible.
View 2 Replies
View Related
Dec 3, 2013
existing workbook that has evolved over several years, there are bits of data spread all over the sheets and there are several sheets.
My question is. Is there a way to show/print/email an alert with a reminder message any time any of the formula cells gets changed, something like "Be aware a formula is being changed, make a note of the changes."
View 8 Replies
View Related
Feb 19, 2009
In my spreadsheet I have column B which has a drop down list using "open" and "closed" as the choices. Whenever someone selects the closed option, I would like for that row to be moved to the next blank row on the tab called CLOSED. Is this possible? I was thinking that if it was it would require some kind of coding. I have attached my spreadsheet for you to look at.
View 2 Replies
View Related
Jun 23, 2009
I chose to place this in programming, as all the functions for this workbook are either macros or Internet Links. Nothing is ever changed on the worksheet.
I have a workbook that is fully protected with passwords both for the workbook and the worksheet. When I set up the protection, no check boxes are checked.
I have macros and internet links on the worksheet that can be selected, but none of them affect the worksheet.
As a matter of fact, I can open the workbook and close it with only "Application.Quit" in a macro and a message box comes up asking if I want to save the changes or not. If I close it with the upper right corner RED X, it still asks the question.
I have no "On Open Macros" or Links of any kind.
I have other workbooks that this does not happen on.
View 10 Replies
View Related
Jan 6, 2014
When I move the range rDes, another range rOrig with the same address gets changed. How can I prevent this?
Code:
Sub Macro1()
Dim rSrc As Range
Dim rDes As Range
Dim rOrig As Range
Set rOrig = Selection
[Code] ........
View 3 Replies
View Related
Mar 23, 2007
the dates in my spreadsheet changed from dd-mm-yyyy to a random 5 digit number. For instance, if I enter in 01-07-2007, it will re format to to 39089. I am trying to fix it, but I can't seem to figure out what happened and how to get all of the dates back to normal. Is there a way to fix this?
View 9 Replies
View Related
Jan 16, 2008
Can you protect a sheet name from being changed by a user?
Can you protect a sheet from being deleted by a user?
I have an Excel 2003 file available to all employees on a network. There are three sheets. Two sheets are protected with passwords and users can not enter any data on them. They are used to hold data needed by the third sheet.
The third sheet (named FORM) is for user input. FORM has a majority of the cells protected with a password. Users can enter information, save the file, print the sheet, or make duplicates of the sheet. The sheet contains data validations, conditional formatting, and formulas.
I have some VBA which acts on all the sheets (even those which users might have inserted) making them visible (very hidden) or not. When a user opens the file (whether for the first time or after adding sheets), I always want them to have FORM unhidden. I have VBA to do this but what if a user changes the name of the sheet? CRASH!
View 9 Replies
View Related
Feb 27, 2009
Is it possible to have a macro run when a date is changed each month instead of clicking on the button. I have a few macros that are ran each month in a spreadsheet (manually) but would I would like to have them run automatically when the date is changed in cell a4 each month (Cell A4 is linked to another spreadsheet tited "Input" here the date is changed each month and all of the other spreadsheets are automatically updated). The date in cell a4 is always the last day of the month. Also the name of the workbook changes each month ( I am not sure if this is important to know).
View 9 Replies
View Related
Apr 6, 2009
I'm looking to display a message if data in the active cell is changed. I'm using the code below to check if data in a cell matches certain criteria:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column = 9 Then
ThisRow = Target.Row
If Target.Value Like "As*" Then
MsgBox "Please add a note about why the biology of this species is distinct the Comments column."
End If
End If
But I have another column where the cells are prefilled with data. This column stores data from a dropdown, such as Critically Endangered, Endangered, Vulnerable etc. I allow the user to change the data in these cells, by selecting an alternative value from the dropdown, but I want to display a message if they change the data in one of these cells.
View 9 Replies
View Related
Sep 30, 2009
The userform takes the data to a worksheet, then i run a pivot table on the worksheet to provide an easy to view summary of entries....
I'd like the user to be able to amend a record if they see an error ... so from the userform how do i do that ? I've read a bit about refedit ( completely ) and a bit about Find...
View 9 Replies
View Related
Oct 28, 2009
I use Excel 2003. With a LOT of help from this board, I've written some macros for a workbook template that will be opened then saved with another name with an .xls extension. The problem is that the macros transfer data to and from another workbook template. Here's the code that's giving me problems.
Windows("BookA.xlt").Activate
Sheets("Sheet1").Select
ActiveWorkbook.Save
Range("A1").Select
Application.CutCopyMode = False
Selection.Copy
Windows("BookB.xlt").Activate
How can I use the macro if I open BookA.xlt then change the name to BookZ.xls for my data entries? At the same time BookZ is open, I may use another instance of BookA.xlt and save that one as BookY.xls. What's the most feasible way to still use the macros?
View 9 Replies
View Related
Nov 4, 2009
I have a userform with many command buttons, one of which allows the user to input a date into a textbox via a pop-up calendar.
Everything works, except the fact that I would like to have the textbox display in the format: Wednesday, November 4, 2009 instead of the format produced by the calendar, which is 11/4/2009.
Does anyone know how to change the value of the output from the calendar?
Here's the code I'm using now:
Scheduler.PubDateBox.Value = Calendar1.Value
View 9 Replies
View Related
