I need a macro to search for certain info on different sheets
combine them and place it on a Report sheet.
This is extensive and complicated so it would be easier if I
emailed the .xls file
If you think you can help, let me email you the file.
I have a combo box in a worksheet with a macro written for it that works fine but when I open the worksheet it doesn't run automatically, I have to find the macro and tell it to run.
How can I get it to run as soon as the worksheet is opened
Here is the code for the macro
Private Sub combobox()
ComboBox1.clear
ComboBox1.AddItem "Mit Rekuperator"
ComboBox1.AddItem "Ohne Rekuperator"
End Sub
Private Sub ComboBox1_Change()
Run "PinchInternHeatExchanger"
Select Case ComboBox1.Text
Case "Mit Rekuperator"
ActiveSheet.Range("I62") = Worksheets("uorc").Range("L99")
Case "Ohne Rekuperator"
ActiveSheet.Range("I62") = Worksheets("uorc").Range("E11")
End Select
Run "PinchPoint"
End Sub
2 worksheets. The first has the raw data and I want to drag some stats onto the second.
I'm trying to make it look in one column on first sheet and identify matches for a range of numbers (say 100 to 199), then where there's a match, look across into another column and count instances of specific inputs (A). ie, 114 has A in column G as does 119 and 199, 115 has B = count will be 3 -
My attempts at stringing combinations of match, IF, Countif and lookup/vlookups have, frankly, been a tad pathetic!
I've built a workbook using Excel 2000 that uses several combo boxes. When I try to protect the workbook the combo boxes become locked, even when I have done FORMAT CONTROL / PROTECTION and unticked the LOCKED box. Is this normal?. I also have data validation cells and they work fine if I unlock them and Protect the workbook. As a result, I am thinking of converting the combo boxes to data validation cells, but should I even need to do this
View 3 Replies View RelatedI'm attempting to make a simple userform that inputs data onto an existing worksheet. I have the userform but would like to use a combo box to choose a "category" item of data, however I dont know what the categories are! I would like the combo box to, somehow, look at the spreadsheet and read off the already entered categories and offer those as choices.
A picture is worth a thousand words:
http://www.copestake.org/images/excel.png
Is there a simple way to fill the combo box (using the form initialize I assume) with the existing categories?
[Edited to link to image instead of displaying on board~admin]
I need a list in my form, simple "Name/Number" list (only two options) but i don't want it to refer to any cell in the worksheet.
I want to input a text in a textbox and with the selection in the list above i want to have multiple choices at how to approach the text (if i input a name i want it to be different than if i input a number). All the info i came up on the web refers to lists made upon a range of cells.
How can i make a list without involving ranges of cells?
I am trying to figure out how to delete a row on a worksheet via a VBA User Form. I currently have a User Form with a Combo Box that is populated by cells in a named range ("PickCategory...") on a worksheet... I am populating thsi box using this
Private Sub UserForm_Activate()
ComboBox1.List = Worksheets("data").Range("PickCategory...").Value
End Sub
First off, I want to include a lable that will display the contents of the cell to the right of the currently selected entry of the combobox on a label (or textbox). So, whatever entry you select in the combo box, the corredponding value (to the right of it on the worksheet) will appear in the text/label
box. Is there something similar to the VLOOKUP that will work in VBA?
Also, what I want to be able to do is to allow the user to select one of the entries from the combo box (which is already working) and then be able to delete the row of that entry on the worksheet. So, the user selects an entry from the combo box and then clicks a "Delete" command button to delete the row of that entry on the worksheet...
I want to create combo box 'on the fly' but i want them to be aligned vertically and horizontally to the cells of the worksheet i.e. i want it to fit into the cells exactly. I would also like it to enlarge its length depending on the size of the values (Text) it holds.
How would i do this?
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 attempting to place a formula in cell b3 in the attached spreadsheet on the "sheet to pull data into" tab 1 (cell is highlighted yellow) to retrieve value in the yellow highlighted cell in the "Sheet that contains data" which is on a seperate worksheet within the same workbook.
The cells highlighted red in the "sheet to pull into" tab (cells: a1, a3, b1, and b3) are the criteria that needs to be matched to those cells on "sheet that contains data" tab in order to ensure the value returned is correct.Sample of problem.xlsx <----see the attached sample spreadsheet.
I am trying to set up a combo box in my workbook so that when the item is selected from the list a particular macro will run according to the selection. I tried with the following codes but wonder why it is not executing when running the macro.
Option Explicit
Sub COUNTRYCURR2()
Dim shtInv As Worksheet
Dim shtT_Country As Worksheet
Dim Row As Long
Dim Row2 As Long
Dim lngEndRowInv As Long
Dim lngT_Country As Long
Set shtInv = Sheets("Inventory")
Set shtT_Country = Sheets("T_Country")
lngEndRowInv = shtInv. Range("A" & Rows.Count).End(xlUp).Row
lngT_Country = shtT_Country.Range("A" & Rows.Count).End(xlUp).Row
shtInv.Cells(1, 19).Value = "Country Code"
shtInv.Cells(1, 20).Value = "Currency Code".................
i need is a macro that once run selects a certain (or multiple) comboboxe's values. Eg I select macro 'test' and it selects value 1 on combo box 1, value 2 on combo box 2 etx..?
View 2 Replies View RelatedI'd like to use a button to run a macro that inserts a combo box, but can't seem to change the properties of that box within the macro. For example, I need to enter the linked cell, but when I run the macro, the actions in the combo box's properties dialogue don't record (I'm not familar with visual basic, so I'm 'recording' the macro).
View 13 Replies View RelatedHow to get a macro that will display a chart based on the values of a combo box?
i have a combo box, with list info
and a button.
what i am aiming for is, if "total A/R" is selected in combo box, when Button is pressed, i want it to display that specific chart.
is that something that is possible?
The first combo box is on a userform so that a subject can be selected
View 3 Replies View RelatedI'm trying to figure out how to activate a macro from combo box or list box.
But no success.
I have a list of names:
AAA
BBB
CCC
111
222
333
That I can view through the combo box.
I have created a list of macros, that carry the same names,
AAA
BBB
CCC
111
222
333
The Q is: how can I link each name to its own macro?
so when chosen, will activate the macro?
I have created a combo box and have inputted the values
Jan, Feb, Mar (think you get the idea).... Dec
I am looking to assign a macro to each value so that each one shows a graph, i have already created the macro’s to show the graphs. Just unsure how to make them work with the combo box
I have worksheet 1 and worksheet 2. I have a different list of names in column A in both worksheets. Some of the names in worksheet 1 are in worksheet 2, but only a partial list. Worksheet 2 names are not in any kind of order and the rows do not match up with worksheet 1. In worksheet 1, column B is filled with each person's email address. In worksheet 2, column B NEEDS to be filled with each person's email address.
Is there a way for me to take each name, sequentially, on worksheet 2 and find that same name in worksheet 1, then pull the email address from column B (beside the name) and copy it to that cell in column B of worksheet 2?
Ive got a cell on a worksheet, that is controlled by a Control combo box. Is there anyway to change the value of the cell, and therefore the combo box, by using a macro. I need the macro to activate when the workbook is exited.
View 3 Replies View RelatedI am trying to create a menu that calls macros based on your choice using a drop down combobox (from the control toolbox). Everything works except: When i try to reset the drop down to "Main Menu" using the Linked cell $B$1 excel hangs and suts down evertime. What i would like it to do is reset the drop down to "Main Menu" each time one of the other drop downs are selected. I have really enjoyed this forum and it has been a great resource for me in the past I hope someone can help. I have attaching the file for review.
View 3 Replies View RelatedI have two combo boxes that both contain 7-12 separate search criteria for the user to choose from. The other includes months and the other value ranges in text form. Based on the selections, e.g. "August" from other and "increased by more than 5 %" from other, I'd like to have a command button to execute the appropriate macro. I've already compiled the macros for each occasion but I just can't figure out how to get the button to execute them. Can I use the Select Case statements? If so, how?
Oh, and whether it's relevant or not, the boxes and the button are from the control toolbar.
I tried both IF and LOOKUP and failed. I'm trying to search for values from one worksheet and identify whether or not those values exist in another worksheet. I attempted the following lookup in field A2:
=LOOKUP(B2,Sheet3!A$2:A$914,Sheet3!C$2:C$914)
B2 (thru B5000 or so) contains values I want to search for; sheet3!A$2:A914 is where I want to look and column C of that same sheet, entered the text "Yes" in an attempt to have the results list "Yes" for hits and N/A for misses. (All fields are text.) I copied the formula all the way down the sheet in column A. The result it is returning is N/A in A2 and Yes in A2 -to the bottom, which is incorrect.
I'm using VBA code to lookup a code and return the description of it from another worksheet.
It works perfectly when I copy the code from the other sheet into the cell used to lookup, or when I enter a code containing a letter. But as soon as I enter the code manually and the code consists of numbers only, it doesn't find the match on the other sheet.
Code:
If Item_insert = Item_codesheet Then
voucherSheet.Range(address).Offset(0, 1).Value = itemcodesSheet.Range("D" & j).Offset(0, 1).Value
End If
I have added watches and converted the codes to string and even though both would be strings, the code doesn't identify them as being similar.
Watch : : Item_codesheet : "700030 " : Variant/String : Module1.Item_to_Description
Watch : : Item_insert : "700030" : Variant/String : Module1.Item_to_Description
I have a workbook with 3 workshhets. In the first worksheet I have companies in a ranked order. Based on the company number, I need to return a value from another worksheet that also has the company number as the key.
The lookup worksheet is FY2008 with the company number in column D and the value to be returned in column F. I know it is simple for you Excel gurus but I am still getting my feet wet.
I have two series of dates – one daily series and the other is the hourly series – running in parallel. The daily series has the values which correspond to them – YES and NO columns which can be either 1 or 0. I need for each line on the hourly series to have the corresponding value of the YES and NO from the daily sheet. I am not sure how this can be done. I need this to be done by formulas only as this sheet only represents a condensed version of the larger workbook.
View 4 Replies View RelatedI currently have 2 worksheets.
Is it possible to link an Excel Spreadsheet to an Access Data (formula) what I am trying to do for example:
In worksheet 1 cell A I have dates start from (01-Aug-06) and in cell B a amount (GBP 12,589.44)
In worksheet 2 cell A I have dates start from (Aug-06) and in cell B a exchange
rate (1.4526)
what I want in sheet 1 cell D formula (if A=AUG) find or mach the same from sheet 2 and get the rate * the B1)
I have got a worksheet called data with values in column M7 to M31 which are only there if they meet a criteria >0
if there is a value in cell M9 only, i would like to select the value of M9 and also the description in B9 and insert this into another worksheet called W1 on row C43 and i43 and repeat on C44 and i44 if values are >0 in M11, this would create 2 rows and would expand if there was more matches >0
I have been working on a macro and am trying to find an answer. To date I have not found what I am looking for so I thought I might ask for assistance.
I have 2 Worksheets that I am working with and I am trying to paste data from one to the other.
The Worksheet1 is my control sheet. The Worksheet2 contains data that I am trying to move to Worksheet1.
Worksheet1 has 3 columns:Ledger #, Balance 1 and Balance 2
Worksheet2 has 2 columns (not named), which are: Ledger # and Balance
I want to move the Balance on Worksheet2 to Worksheet1 and place the data in the Balance 2 column.
For example, the macro would start and look at the value in Worksheet2.A1 and match it against the value in Worksheet1.A5. If there was a match, then the value from Worksheet2.B1 would be pasted in Worksheet1.C5
I have attached a sample workbook.
My goal is to have Worksheet1 have the Ledger # with the 2 different balances (I will balance those 2 columns later).
i already have a random generator and when i have the result number i want to search the number from other worksheet.
View 5 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.