Thread: ListBox edit
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default ListBox edit

Did you populate that listbox via .rowsource?

If yes, try populating it some other way (.additem?).

Geoff wrote:

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


--

Dave Peterson