select

  1. J

    VBA mysql SELECT MD5(tel)

    Hello, I've got problem. I receive phone number hashed by MD5 (00037b319ddf1495b2e7ae64e29a8ef5). I need to get this number from our mysql database. So mysql query is: SELECT MD5(c.mob) phone, c.mob phone1 FROM db_hu.hu_cust c WHERE MD5(c.mob) IN ('00f9758dd73300b4025ea916c8a3e024'); I...
  2. S

    Find duplicates in column, then automatically deletes duplicates

    Hi All, I'm a beginner in terms of VBA and so I need help in finding duplicate data in columns then automatically deletes or selects them for deletion. Here's a macro VBA code I found on the internet but it only displays the word "duplicate" in another column. - Sub sbFindDuplicatesInColumn()...
  3. S

    VBA for finding duplicates values in a column and automatically selects it

    My problem here is there is already a VBA code for finding duplicates but the problem here is that. It still takes too much time to click all the duplicates 1 by 1 just to delete them, for example: Imagine a column filled with 5000 data and the duplicates found are around 1500, I can't possibly...
  4. K

    VBA: Search for value and select and delete row with that value

    Hello everyone, I want to rearrange some data in an excel table. I have a variable ID_Nr defined as double and it is a number between 2 and 100. I want the macro to look for that number in column A and if found select the whole row and delete it. That way I am trying to eliminate all rows with...
  5. G

    Select and copy a range with values and not with formulas

    Hello everyone!! Hopefully somebody can help me! I am using VBA to create an email from Excel that includes in the body of the message a table that I am selecting as an specific range. The problem that I have is: I have not been able to select just the dynamic range that contains values. It...
  6. W

    VBA macro button to select todays date changes formatting???

    Hello I hope somebody can shed some light for me. I have a macro button on my s/sheet that runs pretty well to highlight todays date within a row. However it also red borders the left and right side of the column below and im not sure why? It is quite useful and I would like to have the same...
  7. B

    Combo box

    Hi I created a combo box in the form to select the record and export to excel (I created a button). Please advise how to make the combo box with one blank at the top of the list so that I select the blank, then all record can be exported to excel. Regards
  8. L

    select a value from dropdown list via EXCEL VBA

    i want to select a value from dropdown list and have tried below code, but can't work. please take a look: <select name="fldcusval" nchange="fnSetBankName();fnSetCurrencyList()fnGetCustomer();;displayDetails (this);">..</selec> code ie.Document.getElementsByName("fldcustval").Foucs...
  9. P

    Inventory VBA

    Hello, I've received and modified a simple VBA from another excel and i was wondering if anyone could help me modify even more. The thing i need is that the range of this code would be across all documents worksheets. I1,I2,I3 stays in the first sheet. Date and Name in any other if I2 or I3...
  10. K

    Select range from active cell to copy to other sheet.

    Hello, I have a code that will activate in a set range where the words "complete" are changed. I would like the active cell to select that row, however only from columns B:AB. All i have found is how to select the entire row. Private Sub Worksheet_Change(ByVal Target As Range)If...
  11. A

    VBA Select the excel file for your Vlookup Link

    Hello Guys. Please help me with my little Project. I have this project where i needed to link a database(Process2.excel) to another database(Process1.excel) so that it can automatically compute the offset adjustment(CNC Machinining) based from the Part ID's data from the previous process. The...
  12. H

    Select Filter based in Value

    I would like macro to select the filter in A2 (Financial Year") on sheet summary if Cell c10 on sheet "Data" is zero, otherwise select highest year from Filter Your assistance is most appreciated <b></b><table cellpadding="2.5px" rules="all" style=";background-color...
  13. I

    Update code for userform source

    Hi, I have a userform which has Comboboxes for which i select an item from the drop down list. Once all the boxes are complete i then click my transfer button to entere it on my worksheet. This is the code on my transfer button. Private Sub CommandButton1_Click() Dim i As Integer Dim...
  14. H

    macro to select year in Filter omn Pivot table

    I have a pivot Table on sheet "summary" Where the value in C10 in sheet "Data" is zero, the year to be selected on Pivot filter in B2 must be blank , otherwise select highest year It would be appreciated if some could provide me with code to do this <b></b><table cellpadding="2.5px"...
  15. S

    Pls help how to Add multiple rows with same value of combobox through userform

    I have created a userform Which have a combobox and a text box, save button. Now when i select a value say"ABCD" in combo box, i will mention say number as "5". Now when i click on save button, then 5 rows of value "ABCD" should be created in excel cells in the column i specify. And next time i...
  16. D

    Making a pop-up form work from a merged cell

    Hi, I've used the following code in another workbook to open a calander pop up when I choose a particular cell and then once i've selected the date I want to select another cell. I'm trying to use the same code on another workbook however the cell I want to use to start the pop up is merged...
  17. I

    Search Multiple tables on multiple worksheets - find next item.

    Morning All, I have a search option on my Userform enabling the user to search via Client or Opportunity name, and use the below code to find the result and populate various text/comboboxes on the search form. This enables the user to check it is the correct record before selecting it...
  18. K

    Unprotect worksheet being asked when workbook is opened

    Hi, I have multiple sheets that are protected for using the standard Protect Sheet (select locked cells and select unlocked cells both ticked) but when the workbook is opened it prompts the user to provide the password to unprotect for as many instances that there are locked sheets in the...
  19. M

    filtering with a table

    Hi I have this table Query1 below. I want to return the distinct count of companies where the company is in the list of companies where the filter context of campaign = a and the date is greater than the minimum date of the filter context, which in this case would be 4/1/2019 because the...
  20. I

    Search box code doesnt select correct cell on worksheet

    Morning, I have taken this code from another worksheet & made the edits for it to work on my new sheet. I type in the search box say AB & all the results with AB are shown in the listbox. I select the item i require. My problem is that the item i selected isnt selected on my worksheet in...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top