findvalue

  1. N

    Using Index function in userform

    Hello, Please I need your help I'm trying to find a value reference to two columns, I'v tried it in Excel worksheet, it works fine, but I'm not able to use it in VBA Here is the function that I tested in Excel worksheet in range (I2) and works fine =INDEX(E:E,MATCH(1,(A:A=G2)*(B:B=H2),0))...
  2. K

    userform editing & listbox issue

    i have a userform with -around 10-15 textbook to enter employee info -1 text box to search the employee info by enter their ID -1 listbox to show some of their info, not all I have some stuck with my code below like: when I search a employee, the listbox show all possibilities, by clicking the...
  3. A

    method range of object _worksheet failed

    Im having a runtime error on my code below. can someone please help me. Thank you very much. Private Sub CmdDelete_Click() 'find the row Set findvalue = DataSH.Range("B:B").Find(What:=Me.Emp1.Value, _ LookIn:=xlValues, LookAt:=xlWhole) 'delete the entire row Set Addme =...
  4. M

    Listbox items when a row is selected for Edit it shows on textbox as text but the date display as number

    Basically a listbox on a userform that when row is select for edit it displays on the Textbox as text but with the date it display as number 42516 instead of date format has in the cell 12/10/2017 am using DTPicker Kindly appreciate any idea out there as i was stuck with this for a bit...

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
Back
Top