User Profile

Collapse

Profile Sidebar

Collapse
savakis
savakis
Last Activity: Mar 26 '08, 04:51 PM
Joined: Mar 16 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Selected found items in listbox to found cells in excel

    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...
    See more | Go to post

  • savakis
    started a topic Can not get .Find to find date

    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)...
    See more | Go to post
No activity results to display
Show More
Working...