Can onyone please help me please.
I have duplicate items in column A:A which I find via combobox1. These items are placed in listbox1. I then fill in textbox1 and textbox2 for column C and D, and then fill the found cells with some text. This is OK.
I then have option2 where I am trying to put text in found cells that are only selected in my listbox1 this is set for multiselect.
The option2 does not work. Can anyone...
User Profile
Collapse
-
Selected found items in listbox to found cells in excel
-
Can not get .Find to find date
hello every one.
I can not get this to find the same date on a spread sheet? what is wrong with this.
I put 2 dates in the same. it can find any text though.
Dim Var1 As Range
Set Var1 = Workbooks("Visi ts Numbers.xls").W orksheets("Visi t Nos").Range("AB 209")
Set foundcell1 = ThisWorkbook.Wo rksheets("Visit Nos").Range("AB 210:AB65536").f ind(Var1)...
No activity results to display
Show More