NEED HELP WITH MY CODE - GETTING ERROR MESSAGE
Posted by Montgomery on September 24, 2001 3:50 AM
Hello,
I am having a slight problem with my listbox can someone have a look at this code and see why i am having an error.
Could not set list property/Invalid property value
dim seltext as string
dim i as integer
const perilslbx = 1 "perils in column A
seltext = " ' "
with perilslbx
for i = 0 to perils.listcount - 1
if perils.selected(i) then
seltext = perils.list(i) & " "
end if
next i
end with
Cells(65536, perilscol).end(xlup).Offset(1).value=seltext
Thanks for your help