poceo sam da pravim fajl u kome bi se pravile fakture. Fajl je prilicno jednostavan i potrebno je da ima opcije za pretragu celija, unos datuma, brojanje vec napravljenih dokumenta i jos neke manje funkcije.
Za sada mi je problem da pokrenem formu koja bi pretrazivala sheet=podaci po delu reci iz textbox-a i rezultate pretrage ispisivala u listbox-u u istoj formi.
evo jednog dela koda koji sam pokusao da napisem ali nisam daleko stigao:
ZA UserForm2:
Sub SearchFor(Data As Range, Item As String, Info1 As Long, Info2 As Long, Info3 As Date, Info4 As Date)
Dim rngFind As Range
Dim strFirstAddress As String
Dim lngIndex As Long
With Data
Set rngFind = .Find(Item, LookIn:=xlValues, LookAt:=xlWhole)
If Not rngFind Is Nothing Then
strFirstAddress = rngFind.Address
Do
lisSearchresults.AddItem rngFind.Offset(0, Info1)
lngIndex = lisSearchresults.ListCount - 1
lisSearchresults.List(lngIndex, 1) = rngFind.Offset(0, Info2)
'ListBox1.AddItem rngFind.Offset(0, Info3)
'ListBox1.List(lngIndex, 1) = rngFind.Offset(0, Info4)
Set rngFind = .FindNext(rngFind)
Loop While Not rngFind Is Nothing And rngFind.Address <> strFirstAddress
End If
If rngFind Is Nothing Then
MsgBox ("Nije pronadjen ni jedan klijent. Molim pokusajte ponovo!")
End If
End With
End Sub
'dugme za pretragu
Private Sub cmdSearchPolicy_Click()
Dim shtData As Worksheet
Dim rngSearch As Range
Set shtData = Worksheets("Podaci")
'Select Case TabStrip1.Value
'Case 0
'Set shtData = Worksheets("Podaci")
'Case 1
'Set shtData = Worksheets("Data2")
'Case 2
'Set shtData = Worksheets("Sheet3")
'Case Else
'Exit Sub
'End Select
Set rngSearch = shtData.Range("B:B")
'lisSearchresults.Clear
SearchFor rngSearch, txtSearchPolicy.Text, 1, 2, 3, 4
End Sub
'ciscenje rezultata
Private Sub CommandButton1_Click()
'lisSearchresults.Clear
ListBox1.Clear
Me.txtSearchPolicy.Value = ""
End Sub
Da li neko zna kako da uradim ovo?
nije mi potrebno celo resenje vec samo nagovestaj ili smernica
Unapred zahvalan
Dusan