Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have some option buttons (for now, Opt1 and Opt2), a listbox (ListBox1) and a command button (Cmd1) on a worksheet. Here is the very basic code I have reduced the option buttons to in trying to debug my issue... Private Sub Opt1_Click() ListBox1.Visible = False Cmd1.Visible - False End Sub Private Sub Opt2_Click() ListBox1.Visible = True Cmd1.Visible = True End Sub When I click Opt1, the list box is not visible. When I then click Opt2, the list box is visible and shows the info I expect. The problem is that I am unable to select any rows in the list, or scroll down the list. The command button works as coded (including error hanndling for no selection in the list). Then, I click Opt1 again, the list is hidden, followed by Opt2, the list is now visible again. This time however, I can now select rows in the list, etc. This pattern repeats, so that if click Opt1, then Opt2 again, I will not be able to use the listbox, and then I can. I have checked that the list box is always set to enabled, that the worksheet itself is not protected, and looked for other settings that I thought might be causing this. I am using Excel 2000. Anyone know why this would happen? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Fill a multicolumn listbox with data from a range in another works | Excel Programming | |||
It works .... but only 1 time | Excel Programming | |||
Works every second time | Excel Programming | |||
CopyPicture only works second time | Excel Programming | |||
listbox works in form; not imbedded??? | Excel Programming |