Unselect Forms Toolbar Listbox
 

Hi,
I know that it's possible to unselect the controls toolbar listbox by
changing listindex to -1
but I was wondering if it's possible to unselect the forms toolbar
listbox? It doesn't seem like you can. Thanks, Matt

Unselect Forms Toolbar Listbox
 

On Apr 22, 5:31*pm, Matt wrote:
Hi,
I know that it's possible to unselect the controls toolbar listbox by
changing listindex *to -1
but I was wondering if it's possible to unselect the forms toolbar
listbox? It doesn't seem like you can. Thanks, Matt

I should add that I'm using this control on a worksheet.

Unselect Forms Toolbar Listbox
 

Check out the ReleaseFocus method in VBA help.

"Matt" wrote:

Hi,
I know that it's possible to unselect the controls toolbar listbox by
changing listindex to -1
but I was wondering if it's possible to unselect the forms toolbar
listbox? It doesn't seem like you can. Thanks, Matt

Unselect Forms Toolbar Listbox
 

ActiveSheet.ListBoxes(1).ListIndex = 0

Weird, huh. Why does one start with 0 and the other start with 1???

Matt wrote:

Hi,
I know that it's possible to unselect the controls toolbar listbox by
changing listindex to -1
but I was wondering if it's possible to unselect the forms toolbar
listbox? It doesn't seem like you can. Thanks, Matt

--

Dave Peterson