Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Edit listbox Items | Excel Programming | |||
Select & edit items in a listbox in VBA | Excel Programming | |||
Edit Add Delete Listbox Records | Excel Programming | |||
Edit cell contents via userform listbox | Excel Programming | |||
Edit cell contents via userform listbox | Excel Programming |