Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
comboBox1.Clear 'ovo da izbrise item iz comboboxa ako ih je bilo
Dim LastRow As Long 'zadnji red
Dim rng As Range 'range
Dim ws As Worksheet 'ovo mi se svida nemoram pisati svaki put worksheet
Set ws = Worksheets("ImeList")
ws.Select 'vidis napisem samo ws umjesto worksheet
With ws
LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row 'nade zadnji upotrebljeni red u stupcu A
Set rng = Range("A3:A" & LastRow) ' rangira u stupcu A od A3 do zadnjeg reda
Me.combobox1.list = rng.Cells