Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > Unselect Forms Toolbar Listbox
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 30
Default 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
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 30
Default 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.
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 3,986
Default 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

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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
Forms Toolbar teach1 Excel Discussion (Misc queries) 1 March 20th 08 01:53 PM
Unprotect from Forms Listbox [email protected] Excel Programming 5 January 6th 05 05:40 PM
MS Forms ListBox no longer accessible??? bryan baker Excel Programming 0 September 17th 04 10:45 PM
MultiSelect Listbox (Forms Toolbar) Ryan Holmes Excel Programming 1 July 27th 04 01:16 AM
Unselect data in a Listbox Chris Gorham[_3_] Excel Programming 1 December 31st 03 05:10 PM


All times are GMT +1. The time now is 08:13 PM.

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

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement