disable listitem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Which method do I have to use to disable items in a list- or combobox, so the
user can't select them, without removing them?
Thanks
 
You can disable a listbox entirely like this:

ListBox1.Enabled = False

I do not believe it is possible to disable selecting some but not all items.

--
Jim Rech
Excel MVP
| Which method do I have to use to disable items in a list- or combobox, so
the
| user can't select them, without removing them?
| Thanks
 
Hi

Maybe in the change event this to disable for example the fourth item

Private Sub ListBox1_Change()
If ListBox1.ListIndex = 3 Then ListBox1.Selected(3) = False
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dim item As ListItem 4
using a combobox.selecteditem 1
Select all data in column and list in form combo box 5
Set value of a cell with a dropdown list during run time (C#) 10
Fill combo box ignoring blanks 2
Collection::Item runtime error 6
non-repeating Comboboxes values 9
YouTube error: "If playback doesn't begin shortly, try restarting your device" 0

Back
Top