Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 260
Default Listbox Selection

Hey guys

I have a listbox called ListBox1 and I want to make
frame20.visible = true if any item in listbox1 is selected.


How do I do this?

Thanks
Todd Huttenstine
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default Listbox Selection

Hi Todd

"How" is one side of it, "when" is another. Assuming that code or the user
selects something/nothing in the list and you want it to happen immediately:

Private Sub ListBox1_Click()
Select Case ListBox1.ListIndex
Case -1
Frame20.Visible = False
Case Else
Frame20.Visible = True
End Select
End Sub

HTH. Best wishes Harald

"Todd Huttenstine" skrev i melding
...
Hey guys

I have a listbox called ListBox1 and I want to make
frame20.visible = true if any item in listbox1 is selected.


How do I do this?

Thanks
Todd Huttenstine



Reply
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
Listbox selection ub Excel Discussion (Misc queries) 0 March 10th 09 06:43 PM
Listbox & Selection sparx Excel Discussion (Misc queries) 0 July 31st 06 10:48 PM
ListBox selection GMet Excel Programming 1 September 24th 04 08:02 PM
Listbox multi selection Jorge Rodrigues Excel Programming 3 September 7th 04 11:06 PM
Run a macro when new selection in listbox Georg[_3_] Excel Programming 1 December 5th 03 06:09 PM


All times are GMT +1. The time now is 06:34 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"