cellsrownum

  1. A

    multiple search criteria

    I have this code that searches a list for "Deposit". I would like to search for Deposit & Withdrawal. How can I adjust this code to accomplish this task. Thank you kindly for your help... Do Until Cells(RowNum, 19).Value = "" If InStr(1, Cells(RowNum, 20).Value, "Deposit"...
  2. R

    Populate Table from list box

    Hello, First off this is my first post, normally i can find my solutions but i can't quite figure it out this time, so sorry if this has already been asked. I'm designing a workbook where users can update the data through a userform. Currently the userform has a listbox that pulls from a...
  3. M

    VBA Excel - How to code a filter for a list box search

    Hi, I wanted to make a filter in a text box of a form that returns search results. The search works great. My code for the filter returns a run time error when I make an entry in the text box. Can someone help with a filter code? I want to filter only the fiscal year in column A by entering...
  4. I

    merge/ combine two row based on two separate value

    Hello! I want to be able to loop through a sheet and do the following: if cell value in row 1, column A and B match the cells value of row 2, column A and B AND the cell value in row 1, column O = "REGULAR DELIVERY" and the cell value in row 2, column O = "RETURN", I want to combine/merge the...
  5. A

    Userform VBA without opening worksheet

    Hey community, Can anyone help me please, i use following formula ( userform ) to search and add product to worksheet. Product list is in Stock Data sheet,and it adds found product to Form sheet. but when i click search it is opening Stock Data sheet, can it find and add product without opening...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top