I like the way the names auto fill. Though would ilke to have it so say when roc is entered it shows as a dropdown so you can see that there are more than one ROCHESTER.
Like a search i guess, That would be valid to the first to letters. so if you had name donald, david & daffy when D is entered it showes all three then when DA is showes only David & daffy.
The project that i will 1st use this on is a contact address ph book.
I have a combobox which is manually scrolled through using the down arrow key. As the different combobox items are viewed, I would like to be able to delete the currently viewed item from the list if desired by clicking on a commandbutton.
The list items are contained in the range of B2:B500. Also, since this places a gap in the list, I would like to shift the remaining cells values in column B up to close the gap.
I am having a problem with excel, I need to create a search box, which will be displayed on my first work sheet, which is the summary page and I need to search through all of the information on the other sheets within the excel document, they type of information that I have rages from reference numbers, names and amounts (currency) and once someone has input the information that they are looking for and has found every occurrence it will display this on the summary page, is this something that can be done?
View 9 Replies View RelatedI have a worksheet with List from sharepoint,I need to populate the data in another worksheet using combo box and using the same column that are in the list.
View 12 Replies View RelatedAttached small application. Open the application and click on the LISTBOX button. Code for the Filter by Item button or the Filter by Representative button. I would like to select an item from either of those dropdowns in the search box, click on the relevant button and the list box will populate to show the results.
For example, if I were to select Chocolate Bars from the dropdown and click filter by item, I want to see only the three lines [i.e. line 2, 6 and 7] present in the listbox, and I want to be able to doubleclick on any of those lines to go to the record if I wish.
Similarly, if I select Robert from the other dropdown and click Filter by Representative, I want to see the relevant three lines [i.e. 4, 5 and 8] relating to Robert, present in the listbox, where I can again double click to go to the record [i.e. the data entry userform related to particular record selected.
I have attached a file : Form.xlsm
I am looking to modify my combobox from a userform to Filter the list based on the first entry on what the user will add.
I have a code that will search for all entries in my "Control" sheet and passed this on to my combobox:
[Code] ......
I have, within a module, the following function code that the user find the entry by adding the first 3 letters of the search they need:
[Code] .....
I would like to know what to change in the function to filter the list, once the user adds a first letter and then press the dropdown from the combobox, to filter the list based on all entries from the first letter to only show entries with that letter.
If A is entered, then, show only the entries strating with the starting letter A, but at the same time if the user adds more letter to filter to the first then second letter:
If AB is inserted, then, show entries with AB only.
Where do I add this code also, is this another function or this could be inserted within my function?
Below is my current code. The strFind1 searches for a name within the database and then I need strFind2 to do a exact for a Subproject search and a partial search for everything containing the Subproject selected and other Subprojects. Currently, when the database entry in the worksheet includes Subproject 1 the search function works but when I have an entry that contains Subproject 1/Subproject 4 it does not find the entry. How can I expand the strFind2 to equal what is selected in the Combobox2 and find entries that have what is selected plus more text. I have set the line where I think everything is going wrong to a bold format.
[Code] .....
I am trying to create a combobox to filter a set of data by the month that is entered.
The below code worked fine when there was just the month entered, but now all the entries in the sheet are in the format 01 January 2009. So I need a section of code which will search for the combobox value as part of a string in my range.
The cbodate values are Jan, Feb, March etc ....
I have a worksheet with following values:
A
B
C
1
Shorts
75
[Code]...
Also I have a Userform with 2 ComboBoxes named "ComboBox1" and "ComboBox2". Values in ComboBox1 is "Pull my pants", "Eat my shorts", "Socks for everyone".
What I would like to do is to search though column A and look for any of these textstrings in my selection in ComboBox1 and return the value from column B in column C.
Example: "Pull my pants" is selected in ComboBox1 then the value "pants" should be found in column A and value in column B (25) should be entered in cell C2.
I am fairly new to VBA and have spend hours searching Google and found some formulas like InStr and VLookup. My problem is that I am not sure if these statements will do the job and how to combine them.
After searching this board, I am using a check for this issue to alert when the problem occurs, but I'm hoping to tell Excel to fix the problem itself. The issue occurs when a set of data equals 100%, but when fewer decimals are displayed, the displayed total equals 101% or 99%.
Example:
0.6%
1.6%
97.8%
(Now when the display is changed to no decimal points)
1%
2%
98%
As you can see, the data appears to total 101%, and my boss is being a (insert any comment you probably have about your boss) about me not manually reviewing every single report that goes out for this 1% difference. As there are probably 400 different points at which this situation can occur on a daily basis, working harder is not the solution. /rant
I thought I once heard about a formula or setting where Excel will only calculate the displayed values instead of the actual value or formula. Ideally, the formula would know to take the three values, figure out the 100% limitation, and round the largest one down so the other two can round up. The example above is probably 99% applicable, as we would be rounding the largest value down in order to round the other values up.
Meaning intended result:
1%
2%
97%
I've data from A1 till G1. Now I will hide column B & D I just want to have total of displayed columns that must ignore values written in column B & D
View 1 Replies View RelatedI have a worksheet I use at work that calculates volume proccesed hourly, and also shows a running total as you enter hourly figures into the table, my question is can you hide everything in the result cell until the figures for each hour are entered ? currently all the result cells have irrelevant numbers in them until you enter the hours figure and the formulas do there thing, I could relly do with them being blank until the relevant hours information is input?
View 2 Replies View RelatedI want no time functionality nor any calculation of the entries. I simply want to type into a cell for example: 0908 and have it displayed as 09:08. I tried custom formatting the cell to hh:mm but then it displays as 00:00.
This is for a real-time incident logging sheet and the less the operator has to type, the better. I know it is only an extra Shift+: but it will be so much easier without having to do it.
I am just wondering if there is a way to allow a macro to continue running in the background once a userform has been displayed? I have disapled the 'close' button and the last action of the macro is to re-enable it.
I want to sum cell A1 and result will be displayed in B1
AB1ValueResult29292.50*10+8952*15+8550*10
Using the below code, I want data in range with format (for ex: J2:K7) to be displayed in the email sent in the place of Email_Body1 place.
Private Sub CommandButton1_Click()
Range("H2").Value = Date
Dim myOutlook As Object
Dim myMailItem As Object
Dim FName As String
Dim i As Long
[Code]....
I'm creating a customized, interactive calendar with several drop-down menus included for each day of the week. I want to have a self-adjusting section at the bottom of each month that shows which values have not been selected in the drop-down menus on any day.
I have a column next to the source list for the drop-down menus with =IF(ISNA(MATCH formulas to show if a value has been selected anywhere on the calendar. If no one has selected a certain value from any of the drop-down menus then "XXXXX" shows up in the row next to its source (one "X" for each column, Mon-Fri). If a value has been selected, then it says "FALSE".
I now want to have a section that lists only the values that have not been used, with "XXXXX" next to the source data. However, any formula I use is not able to differentiate between "FALSE" and "XXXXX" because they are both "0" values in a numerical sense. Can I create a formula that references the displayed value, rather than its true numberic value? What formula would be best to use to list only data not being selected from the drop-down menus? Is there a simpler way of displaying this information than what I'm trying to do?
I have a column with dates in the following format: dd/mm/yyyy h:mm
but im doing an XML export and excel only exports in text format. I would like to somehow resterize or only use the displayed amount instead of the text which is exported (ie- 37805.1640277778)
I have a macro that once clicked shows my userform. Is it possible to have this userform displayed whilst also allowing the user to click into other cells on the worksheet?
View 9 Replies View RelatedOn my worksheet, cell A1 and A2 both contain the value:
0.1655555
I've changed the number formatting to three decimal places so it appears on the sheet as 0.166.
In cell A3 I have a forumla =A1+A2 which currently comes back with the value 0.331 (0.1655555+0.1655555=0.331).
Instead of adding together 0.1655555 I want it to add the displayed value of 0.166 so it should then come back with the value 0.332.
While working within the same worksheet, why not put all the routines in one Module instead of using different modules?
BTW, what made me raise the above question is that I have 2 modules in my test worksheet. But when I go to Tools | Macro | Macros > This Workbook, it does NOT show the sub-routines of the first module
I have created several records, each record is in it's own row. I'd like for the row to be displayed if the name of that row is selected in a drop down. How can this be accomplished? I've attached the spreadsheet to show my current progress. When a player is selected in a drop down, I would like for that players record to be displayed below the drop down.
UFC.xlsx
I need to display a subtotal amount in a field named Invoice Total in my spreadsheet. I created a subtotal, which is the amount that I need on each line in the invoice total column. Here is an example:
Invoice Number, Invoice Total, Line_Item_Total
99223, 0, 8.77
99223, 0, 8.77
99223, 0, 17.55
99223, 0, 8.77
subtotal: 43.86
99527, 0, 8.77
subtotal: 8.77
I have the need to create a workbook that will return values based on the entering of an abbreviation. I will use the chemical elements as an example, I wish to have a column formatted so that if 'Au' is entered the cell populates with 'Gold' or if 'Pb' is entered then the cell is populated with 'Lead'
So in my case I have all the abbreviations in one column and all the full descriptions in another (approx 500 different codes/description)
I am trying to have a cell in a diffrent work sheet display information from another sheet.
I entered ='Weapons Table'!A48 and it is displaying in text not what is actually in that cell.
on the cell above it I have entered ='Weapons Table'!A47 and it displays fine.
I've tried typing = then just clicking the cell, and it is still just displaying it as text. I've spent 3 days on this sheet and have only 1 error, that is driving me crazy.
I created a drop down list in three cells for date, month and year using data validation.
But I need these cells to display by default DD,MM,YYYY.
what's the way to do it.
I want to be able to record the highest value displayed in a cell (b2) in another cell (c2). Cell b2 is a cell that has continuously updating numbers from a live feed, which are updated approximately every second.
--I'm not sure if I need to have a log created based on the changing numbers. If so, I wouldn't anticipate the length of time to determine the highest value would be more than 7 hours.
--Is there a function/filter that would be able to report the highest number recorded?
I have a program with a line that deletes a worksheet like so: Sheets(Output).Delete. Where "Output" is the name of the sheet (a string). This works fine, but everytime this line is excecuted excel pops up a message box "Data may exist is the sheet(s) selected for deletion. To permanently delete the data, press Delete." and I have to click delete. Is there anyway to stop this message being displayed?
View 2 Replies View RelatedI am currently having a very painful problem with dates.
Currently I assign a value which happens to be a date to a string.
I have an expense sheet calculated, need to show the sum of the "+" number in
a cell that does a subtraction of 2 numbers .. income and subsidized ... as a
- that it negitave amount in red if it is less than a specific numbe. ie 2500