Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing selection focus in listbox
A listbox with multi select single is used to both add and subtract from
a total. Click on a row first time and it adds, click on the same row again and it is removed from the total. The latter is in case an incorrect row is selected in the first instance. However, if a row is selected and then the operator realises it was an incorrect choice, the same row cannot be reselected until some other row is clicked to take the selection focus away from the first row. What line of code will remove focus from a selected line in the list box to allow it to be selected again immediately? Craig Wilks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing selection focus in listbox
Try this Graig
for i = 0 to listbox1.Listcount-1 listbox1.Selected(i) = False Next -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Craig Wilks" wrote in message ... A listbox with multi select single is used to both add and subtract from a total. Click on a row first time and it adds, click on the same row again and it is removed from the total. The latter is in case an incorrect row is selected in the first instance. However, if a row is selected and then the operator realises it was an incorrect choice, the same row cannot be reselected until some other row is clicked to take the selection focus away from the first row. What line of code will remove focus from a selected line in the list box to allow it to be selected again immediately? Craig Wilks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing selection focus in listbox
Where is the Listbox located? There are different events associated with a
listbox when used on a userform and when used on a worksheet. Assume a Listbox from the control toolbox toolbar. -- Regards, Tom Ogilvy Craig Wilks wrote in message ... A listbox with multi select single is used to both add and subtract from a total. Click on a row first time and it adds, click on the same row again and it is removed from the total. The latter is in case an incorrect row is selected in the first instance. However, if a row is selected and then the operator realises it was an incorrect choice, the same row cannot be reselected until some other row is clicked to take the selection focus away from the first row. What line of code will remove focus from a selected line in the list box to allow it to be selected again immediately? Craig Wilks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show cell selection when excel not in focus + other questio | Setting up and Configuration of Excel | |||
Listbox selection | Excel Discussion (Misc queries) | |||
Removing a listbox from excel spreadsheet | Excel Worksheet Functions | |||
Listbox & Selection | Excel Discussion (Misc queries) | |||
Simulating the Format Painter, Selection.Select, and taking focus | Excel Programming |