Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
I have a listbox on a worksheet. When I leave the worksheet and go to
another worksheet or go to a userform from the worksheet and return back, how do I make it so that none of the items in the listbox are selected? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
If it is from the Control Toolbox and is single select:
Listbox1.ListIndex = -1 "ranswrt" wrote: I have a listbox on a worksheet. When I leave the worksheet and go to another worksheet or go to a userform from the worksheet and return back, how do I make it so that none of the items in the listbox are selected? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
I tried what you suggested and got
Run-time error '424': object required I tried Sheets("Home").OLEObjects("ListBox1").ListIndex = -1 'Home' is the sheet that contains 'ListBox1' I got this error Run-time error '438': Object doesn't support this property or method. I put the listbox in using the control toolbox. Any Ideas as to what I am doing wrong? "JLGWhiz" wrote: If it is from the Control Toolbox and is single select: Listbox1.ListIndex = -1 "ranswrt" wrote: I have a listbox on a worksheet. When I leave the worksheet and go to another worksheet or go to a userform from the worksheet and return back, how do I make it so that none of the items in the listbox are selected? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
Yes, I gave you as much as you gave me. You didn't say where it was located.
But by now, I thought you would know that you must specify the parent object such as a sheet or a UserForm. "ranswrt" wrote: I tried what you suggested and got Run-time error '424': object required I tried Sheets("Home").OLEObjects("ListBox1").ListIndex = -1 'Home' is the sheet that contains 'ListBox1' I got this error Run-time error '438': Object doesn't support this property or method. I put the listbox in using the control toolbox. Any Ideas as to what I am doing wrong? "JLGWhiz" wrote: If it is from the Control Toolbox and is single select: Listbox1.ListIndex = -1 "ranswrt" wrote: I have a listbox on a worksheet. When I leave the worksheet and go to another worksheet or go to a userform from the worksheet and return back, how do I make it so that none of the items in the listbox are selected? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
Sheerts("Home").ListBox1.ListIndex = -1
Will work with a Control Toolbox listbox but it does not go blank, it just gives it a Null value. You can include a blank cell in your rowsource for the first cell and use Sheets("Home").ListBox1.ListIndex = 0 That will select the empty cell to display. "ranswrt" wrote: I tried what you suggested and got Run-time error '424': object required I tried Sheets("Home").OLEObjects("ListBox1").ListIndex = -1 'Home' is the sheet that contains 'ListBox1' I got this error Run-time error '438': Object doesn't support this property or method. I put the listbox in using the control toolbox. Any Ideas as to what I am doing wrong? "JLGWhiz" wrote: If it is from the Control Toolbox and is single select: Listbox1.ListIndex = -1 "ranswrt" wrote: I have a listbox on a worksheet. When I leave the worksheet and go to another worksheet or go to a userform from the worksheet and return back, how do I make it so that none of the items in the listbox are selected? Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
Thanks I'll try that.
"JLGWhiz" wrote: Sheerts("Home").ListBox1.ListIndex = -1 Will work with a Control Toolbox listbox but it does not go blank, it just gives it a Null value. You can include a blank cell in your rowsource for the first cell and use Sheets("Home").ListBox1.ListIndex = 0 That will select the empty cell to display. "ranswrt" wrote: I tried what you suggested and got Run-time error '424': object required I tried Sheets("Home").OLEObjects("ListBox1").ListIndex = -1 'Home' is the sheet that contains 'ListBox1' I got this error Run-time error '438': Object doesn't support this property or method. I put the listbox in using the control toolbox. Any Ideas as to what I am doing wrong? "JLGWhiz" wrote: If it is from the Control Toolbox and is single select: Listbox1.ListIndex = -1 "ranswrt" wrote: I have a listbox on a worksheet. When I leave the worksheet and go to another worksheet or go to a userform from the worksheet and return back, how do I make it so that none of the items in the listbox are selected? Thanks |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
I know there is an easy answer to this but I'm not getting it. I did a real
simple code to check this Sub testlistbox() Dim a As String Sheets("Home").OLEObjects("ListBox1").ListIndex = -1 a = Sheets("Home").OLEObjects("ListBox1").Value MsgBox (a) End Sub When I run this I get an error on the first line. I put a ' to skip the first line and I get the same error. When I run this there is a item highlighted in the listbox. The error I get in the two instances is: Run-time error '438': Object doesn't support this property or method. I know there is an easy solution, but what am I doing wrong? "JLGWhiz" wrote: Sheerts("Home").ListBox1.ListIndex = -1 Will work with a Control Toolbox listbox but it does not go blank, it just gives it a Null value. You can include a blank cell in your rowsource for the first cell and use Sheets("Home").ListBox1.ListIndex = 0 That will select the empty cell to display. "ranswrt" wrote: I tried what you suggested and got Run-time error '424': object required I tried Sheets("Home").OLEObjects("ListBox1").ListIndex = -1 'Home' is the sheet that contains 'ListBox1' I got this error Run-time error '438': Object doesn't support this property or method. I put the listbox in using the control toolbox. Any Ideas as to what I am doing wrong? "JLGWhiz" wrote: If it is from the Control Toolbox and is single select: Listbox1.ListIndex = -1 "ranswrt" wrote: I have a listbox on a worksheet. When I leave the worksheet and go to another worksheet or go to a userform from the worksheet and return back, how do I make it so that none of the items in the listbox are selected? Thanks |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
Worksheets("Home").OLEObjects("ListBox1").Object.L istIndex = -1
But if you set the .listindex to -1, then the next line (.value) won't work. Option Explicit Sub testlistbox() Dim a As String With Worksheets("Home").OLEObjects("ListBox1").Object .ListIndex = -1 'or 3 If .ListIndex < 0 Then a = "Nothing chosen" Else a = .Value End If End With MsgBox a End Sub ranswrt wrote: I know there is an easy answer to this but I'm not getting it. I did a real simple code to check this Sub testlistbox() Dim a As String Sheets("Home").OLEObjects("ListBox1").ListIndex = -1 a = Sheets("Home").OLEObjects("ListBox1").Value MsgBox (a) End Sub When I run this I get an error on the first line. I put a ' to skip the first line and I get the same error. When I run this there is a item highlighted in the listbox. The error I get in the two instances is: Run-time error '438': Object doesn't support this property or method. I know there is an easy solution, but what am I doing wrong? "JLGWhiz" wrote: Sheerts("Home").ListBox1.ListIndex = -1 Will work with a Control Toolbox listbox but it does not go blank, it just gives it a Null value. You can include a blank cell in your rowsource for the first cell and use Sheets("Home").ListBox1.ListIndex = 0 That will select the empty cell to display. "ranswrt" wrote: I tried what you suggested and got Run-time error '424': object required I tried Sheets("Home").OLEObjects("ListBox1").ListIndex = -1 'Home' is the sheet that contains 'ListBox1' I got this error Run-time error '438': Object doesn't support this property or method. I put the listbox in using the control toolbox. Any Ideas as to what I am doing wrong? "JLGWhiz" wrote: If it is from the Control Toolbox and is single select: Listbox1.ListIndex = -1 "ranswrt" wrote: I have a listbox on a worksheet. When I leave the worksheet and go to another worksheet or go to a userform from the worksheet and return back, how do I make it so that none of the items in the listbox are selected? Thanks -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
Thanks that explains it better
"Dave Peterson" wrote: Worksheets("Home").OLEObjects("ListBox1").Object.L istIndex = -1 But if you set the .listindex to -1, then the next line (.value) won't work. Option Explicit Sub testlistbox() Dim a As String With Worksheets("Home").OLEObjects("ListBox1").Object .ListIndex = -1 'or 3 If .ListIndex < 0 Then a = "Nothing chosen" Else a = .Value End If End With MsgBox a End Sub ranswrt wrote: I know there is an easy answer to this but I'm not getting it. I did a real simple code to check this Sub testlistbox() Dim a As String Sheets("Home").OLEObjects("ListBox1").ListIndex = -1 a = Sheets("Home").OLEObjects("ListBox1").Value MsgBox (a) End Sub When I run this I get an error on the first line. I put a ' to skip the first line and I get the same error. When I run this there is a item highlighted in the listbox. The error I get in the two instances is: Run-time error '438': Object doesn't support this property or method. I know there is an easy solution, but what am I doing wrong? "JLGWhiz" wrote: Sheerts("Home").ListBox1.ListIndex = -1 Will work with a Control Toolbox listbox but it does not go blank, it just gives it a Null value. You can include a blank cell in your rowsource for the first cell and use Sheets("Home").ListBox1.ListIndex = 0 That will select the empty cell to display. "ranswrt" wrote: I tried what you suggested and got Run-time error '424': object required I tried Sheets("Home").OLEObjects("ListBox1").ListIndex = -1 'Home' is the sheet that contains 'ListBox1' I got this error Run-time error '438': Object doesn't support this property or method. I put the listbox in using the control toolbox. Any Ideas as to what I am doing wrong? "JLGWhiz" wrote: If it is from the Control Toolbox and is single select: Listbox1.ListIndex = -1 "ranswrt" wrote: I have a listbox on a worksheet. When I leave the worksheet and go to another worksheet or go to a userform from the worksheet and return back, how do I make it so that none of the items in the listbox are selected? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |