LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Edit listbox Items vandaley Excel Programming 0 October 8th 06 10:26 AM
Select & edit items in a listbox in VBA poppy Excel Programming 6 May 12th 06 01:10 PM
Edit Add Delete Listbox Records [email protected] Excel Programming 17 October 10th 05 11:58 PM
Edit cell contents via userform listbox N E Body[_15_] Excel Programming 0 October 22nd 04 04:49 PM
Edit cell contents via userform listbox N E Body[_13_] Excel Programming 1 October 21st 04 01:13 AM


All times are GMT +1. The time now is 03:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"