LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 87
Default 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)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros: Step Thru Works, Run Works, Keyboard Shortcut Locks up BEEJAY Excel Programming 2 October 3rd 06 06:46 PM
Alt-Tab works differently if Form called from Menu or Buttonbar Icon seisman Excel Programming 5 August 2nd 05 10:36 AM
How do I convert works file to excel without works software? CatMB Excel Discussion (Misc queries) 1 June 21st 05 04:12 PM
listbox works in form; not imbedded??? jasonsweeney[_66_] Excel Programming 3 April 15th 04 10:24 PM


All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"