Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form works once only
This routine works once, but fails on subsequent occassions.
Private Sub wholemonthbutton3_click() ListBox1.ListIndex=0 ListBox2.ListIndex = ListBox2.ListCount - 1 ' This line fails Msgbox "Listbox2.Value = " & ListBox2.Value _ & " Count =" & ListBox2.ListCount end sub The first time the sub works. The second time ListBox2.value ="" When the OK button is hit I have Unload Me. When the routine has returned to the calling program I have Unload DatesForGraph. Before the routine is called again I have the same statement. So I think it should be unloaded 3 times but still it gives me the wrong answer! Please advise where am I may be going wrong. (Excel 2003) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form works once only
is there any data in listbox2 ?
you aren't clear on why you get the wrong answer, and if the form is unloaded, does the forms load event correctly populaet whatever listboxes you have? Remember that if you unload a form, then any changes that were made are lost unless saved somewhere else and re-loaded. Use HIDE to preserve values. "Gleam" wrote: This routine works once, but fails on subsequent occassions. Private Sub wholemonthbutton3_click() ListBox1.ListIndex=0 ListBox2.ListIndex = ListBox2.ListCount - 1 ' This line fails Msgbox "Listbox2.Value = " & ListBox2.Value _ & " Count =" & ListBox2.ListCount end sub The first time the sub works. The second time ListBox2.value ="" When the OK button is hit I have Unload Me. When the routine has returned to the calling program I have Unload DatesForGraph. Before the routine is called again I have the same statement. So I think it should be unloaded 3 times but still it gives me the wrong answer! Please advise where am I may be going wrong. (Excel 2003) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form works once only
Listbox2 displays the correct data every time.
I have several forms in the file and wonder if I have another ListBox2 in a different form and Excel is getting confused. I am thinking of trying this when I get a chance: DatesForGraph.ListBox2.ListIndex = DatesForGraph.ListBox2.ListCount - 1 Listbox2.Value = DatesForGraph.Listbox2.Value where form name=DatesForGraph "Patrick Molloy" wrote: is there any data in listbox2 ? you aren't clear on why you get the wrong answer, and if the form is unloaded, does the forms load event correctly populaet whatever listboxes you have? Remember that if you unload a form, then any changes that were made are lost unless saved somewhere else and re-loaded. Use HIDE to preserve values. "Gleam" wrote: This routine works once, but fails on subsequent occassions. Private Sub wholemonthbutton3_click() ListBox1.ListIndex=0 ListBox2.ListIndex = ListBox2.ListCount - 1 ' This line fails Msgbox "Listbox2.Value = " & ListBox2.Value _ & " Count =" & ListBox2.ListCount end sub The first time the sub works. The second time ListBox2.value ="" When the OK button is hit I have Unload Me. When the routine has returned to the calling program I have Unload DatesForGraph. Before the routine is called again I have the same statement. So I think it should be unloaded 3 times but still it gives me the wrong answer! Please advise where am I may be going wrong. (Excel 2003) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros: Step Thru Works, Run Works, Keyboard Shortcut Locks up | Excel Programming | |||
Alt-Tab works differently if Form called from Menu or Buttonbar Icon | Excel Programming | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
listbox works in form; not imbedded??? | Excel Programming |