I have a workbook with 4 sheets. I created a combo box in the first sheet which I named "Main". The items in the combo box are John, Mary and Peter. The other 3 sheets are named: John, Mary and Peter. What is the right code so that when I select a name from the combo box, say John, it will bring me to the sheet named "John".
View 7 RepliesI've got a Combo Box that I want to be able to attribute Hyperlinks to. I would like to be able to select one of the options from the Combo Box and have the Hyperlink fire automatically. The conditions are:
Workbook Name: Floor Plan
Combo Box Worksheet Name: Switched 2
Input range: 'Combo Box'!$A$1:$A$4
Cell link: $CU$80
Drop down lines with corresponding Hyperlink Named ranges:
R FRONT R_FRONT_Hardwired
L REAR Audio_1_AZ80
120V-60HZ 4A ER_16_PC_100A_Outlet_6
R REAR Audio_1_AZ80
I've attached the Code as text.It is not working and I'm sure there are a number of reasons why.
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?
i am making a simple complaint tracking system and there is a column where there are two choices Resolved and Unresolved if you choose resolved it copies the row to the resolved sheet and if it's unresolved it copies the row to the unresolved sheet. i attached a template to give you an idea, i want the first complaint to be copied to the resolved sheet and second one to the unresloved sheet, i don't want the status column which contains the choices to be copied to the other sheets, also the unresolved sheet doesn't have a 'date closed' column because the complaint is not yet resolved so i dont want it to be copied there, i want it only in the resolved sheet.
[URL]
I have a excel file to keep track of sales pipeline. What I am looking for, is an automated utility or code that will allow excel to automatically move entire rows once a task is completed and can be moved to another sheet. In Prospect sheet I have a column for " sales stage" and here you have to select from a drop down menu, either "Prospect", "semi-qualifed" "Pre-qualified" "verbal" "closed-won" and Lost. What I would like, is that once you have selected one of the sales stage, the entire row or entry, will be automatically moved to a new sheet according to each stage.
View 9 Replies View RelatedI need to place a dropdown box with three options in all cells in lets say column C.
View 3 Replies View RelatedHow do I change the below code to fill all combo boxes all on sheets. All the names of the controls should be the same on each sheet since each sheet was created from a copy of the original.
View 5 Replies View Relatedhow to add drop list box or combo box in this yearly time sheet so every employee has his own record in this time sheet so when ever i select name from drop list all info changed, i did include table in sheet 1 as an example.
View 4 Replies View RelatedThe first combo box is on a userform so that a subject can be selected
View 3 Replies View RelatedI 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 RelatedI 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.
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 RelatedI am trying to use lookup to return the value when the condition of two cells are met.....
View 10 Replies View RelatedI'd like my macro to pop up the window that'd ask where I'd like my pdf file (exported from excel) to be saved. How can I do that? I understand that the code below will assign the name for the file and save it to desktop.
Code:
Sub SavePDF()
Dim MyFullName As String
MyFullName = "C:UsersqlarimerDesktopFilename.pdf"
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=MyFullName, _
Quality:=xlQualityMinimum, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub
I need to insert multiple images into a worksheet every 45 rows in and a specific column. I have sourced from other threads a means to insert multiple images but they are all inserted in the one cell.
What I require is the means to either place them directly into specific cells or move them to the correct cells once in the worksheet.
As you will see I am also attempting to resize the images once they have been inserted.
Below is the code I have thus far.
Sub Insert_Pict()
Dim Pict As Variant
Dim ImgFileFormat As String
Dim PictCell As Range
Dim Ans As Integer
Dim newPicture As Shape
I need to go to named cells in a workbook based on a selection in a combobox - I just can't seem to work out the coding -
View 4 Replies View RelatedI have a workbook containing over 75 sheets. I would like to print only a select few of those sheets using a macro. I did download the "sheets to print" workbook submitted by Dave Hawley ,and have tried (in vain) to adapt the code so that it does not display ALL of the workhseets in the userform box. I want to limit the sheets displayed in this box to onnly those that I name.
View 8 Replies View RelatedI want to select the file name from the window which appear from the coding below,to be pasted in my textbox in userform.With only the coding below,I can only select my required file name(.txt) and afterwards, the file will be sorted into excel sheet.Before this,I set my Userform in such a way,user have to copy paste the path of the file into appropriate textbox.Itīs already functioned.I wish to alter the userform to be more user-friendly.Instead of copy paste the path,user can click the BROWSE button which I put next to the textbox,and the file can be selected.
Private Sub cmdBrowse_Click()
Dim b As Boolean
b = Application.Dialogs(xlDialogFindFile).Show
End Sub
The file should not have been sorted automatically because,user need to type in another inputs before running the process.
I've created drop down box using VBA code. Data for drop down box is on the Sheet2 and drop down box created on Sheet1. Need code I have to use to copy selected value from box to any cell on Sheet1 (i.e. Sheet1.A5). Here is my
Private Sub Workbook_Open()
CreateMyBox
End Sub
Sub CreateMyBox()
Dim MyBox As Excel.Shape
With ActiveSheet
Set MyBox = .Shapes.AddFormControl(xlDropDown, 5, 17, 175, 15)
End With
With MyBox
.Name = "MyBox"
.Fill.ForeColor.RGB = RGB(255, 0, 0)..................
compare one coloum with another and return a corresponding value in the adjacent cell. For example
I have 4 colums A,B,C,D. In "column A" I enter Products names (Example- Apple, Orange..)and in corresponding Coloumn B, I enter Product Codes (01 for Apple and 02 for Orange etc..) When I enter Apple in coloumn C for 10 rows (C1 thru C10), I need to get Code 01 in Column D in all rows (D1 thru D10)
I cant figure out how to do this, see attached example
I want to use a drop down list on sheet 1 to select a cell from column 1 on sheet 2 and fill in cell e1 with data from column 1 and 3 on sheet 2?
I'm trying to find out how I get a cell to automatically find a code based on the selection of a drop down menu. If drop down menu selction is Rent I want the cell to automatically find the code for rent 61100. It's a large selection that will grow alot bigger than it currently is so needs to also have growing room.? I can't seem to find any answers on here already that seem to work on this, (or understanding them is maybe my fault). I've attached the sheet
View 3 Replies View RelatedI'm looking to use a drop-down to allow me to highlight a complete row depending on what I choose, each row is unique.
So if my drop-down is say 20 different words and I choose "Oil" I want it to look down the table and highlight the row that shows oil prices.
Example of column A might be as shown below (Starting in say A3).
(A3)Petrol
(A4)Wood
(A5)Oil
(A6)F/Fuel
(A7)Other
From my drop-down located in A1 I choose "Oil" I want it to select only row A5 and either highlight it or blank out the rest.
[URL]
I had this posted in Formulas and functions
I have 20 sheets in a work book (1-20) with similar row details(80 rows)...but the columns have amounts for 12 months. I would like to do a sum if function based on months chosen.
For eg: If I select "sheet 1" and choose month as june...I want the sum of amounts from Jan-June.
I am using the follow Array formula to display the value selected in an Autofilter:
{=LOOKUP(REPT("z",25),IF(SUBTOTAL(3,OFFSET($A$4:$A$585,ROW($A$4:$A$585)-MIN(ROW($A$4:$A$585)),,1)),$A$4:$A$585))}
The flaw in this formula, is that it displays a result even when no value has be chosen. Is there a way to display a value only once it has been chosen in the Autofilter?
How would I add a YesNo MsgBox to my existing macro that I have set up through a commancd button? I would like the user prompt to ask the following ? ---> "Would you like to move the data sheet forward 1 week?". Then if "Yes" is selected, run the following macro. If "No", end the subroutine.
Private Sub CommandButton6_Click()
Range("M7:BL156").Select
Selection.Copy
Range("L7").Select
ActiveSheet.PasteSpecial Format:=3, Link:=1, DisplayAsIcon:=False, _
IconFileName:=False
Range("I4").Select
ActiveSheet.Range("L6").Value = Range("L6").Value + 7
End Sub
Is there a way to calculate a conditional minimum? I have a range of 1000+ values and I need to find the minimum, but the minimum has to be greater than a specified minimum threshold
View 2 Replies View RelatedI am trying to find a formula that references a cell on a spreadsheet (H7) which is really a Combo Box that is located on a range of cells K25:K30. I want to put a formula in H18, but of course, the combo box always references the range on K. i have tried the $K$25:K430, but i don't know what i am doing. The drop down menu and everything works fine, but the data IS stored elsewhere. HOW do i tell Excel to look at K25:K30,(depending on choice within combo) and then ad H8:H19? I have looked, but all answers are for forms. I am doing this for final exercise for a university course, and (hmmhmm) must folllow obtuse instructions.
View 7 Replies View RelatedIs there a way that I can click on a link in a worksheet that is linked to a data list in in another sheet and display the results in a text box on the original sheet containing the link.
For example ...