I was trying to calculate value in a listbox's cell, no error shows, but it wont work,
dim ox as integer for ox=0 to ListBox1.Listcount-1 dim g as integer g=val(Listbox1.cell(ox,7)) if g<=100000 then if g>0 then Listbox1.cell(ox,14)=str(val(Listbox1.cell(ox,6))*1000) end if end if next
without this line its worked,
if g>0 then
but i want to calculate it, if the columns not empty or zero
anything that i missed ?