Thread: ListBox edit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff Geoff is offline
external usenet poster
 
Posts: 371
Default ListBox edit

Hi
I have a 2 column listbox on a form and a textbox and I want to amend a
selected listbox item via the textbox entry.

When I select a value in the listbox for example:
OriginalValue = lboList.List(lboList.ListIndex, 1) = 6.14

And the value to be added (or subtracted) entered in the textbox = 12.00

Then I would expect this to work:

lboList.List(lboList.ListIndex, 1) = OriginalValue + 12.00

but it gives an error 'Could not set the list property. Permission denied.'
Indeed any value I try to set such as 'rubbish' gives an error.

What am I doing wrong?

T.I.A.

Geoff