Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box value problem
I have several list boxes on a user form, with option buttons. For most of
the listboxes I retrieve the selected value like this (for listbox "lbShift"): Private Sub lbShift_Click() Shift = lbShift.Value End Sub This works well and behaves as I expected. I then added one more listbox and tried to get the value the same way: Private Sub lbNumHours_Click() NumHours = lbNumHours.Value End Sub But a value never gets assigned to NumHours. I've compared everything I can think of between the different list boxes and can't figure out why most of them work, but the one I added today doesn't. If I edit the Sub I'm using it in to use "lbNumHours.Value" instead of "NumHours" it works. Why? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List box value problem
Put a breakpoint on the line
NumHours = lbNumHours.Value and see if it actually gets there. Perhaps the name changed. What's the declaration of NumHours? Maybe it exists only in that sub because you didn't Dim it? "callbr549" wrote in message ... I have several list boxes on a user form, with option buttons. For most of the listboxes I retrieve the selected value like this (for listbox "lbShift"): Private Sub lbShift_Click() Shift = lbShift.Value End Sub This works well and behaves as I expected. I then added one more listbox and tried to get the value the same way: Private Sub lbNumHours_Click() NumHours = lbNumHours.Value End Sub But a value never gets assigned to NumHours. I've compared everything I can think of between the different list boxes and can't figure out why most of them work, but the one I added today doesn't. If I edit the Sub I'm using it in to use "lbNumHours.Value" instead of "NumHours" it works. Why? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List Problem--Please help? | Excel Discussion (Misc queries) | |||
List Problem--Please Help! | Excel Programming | |||
List box problem | Excel Discussion (Misc queries) | |||
List Box Problem | Excel Programming | |||
LIst Problem | Excel Worksheet Functions |