Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
forms
Changed modal property and it worked. Shouldn't have to
do that but alls well that ends well -----Original Message----- I am creating an application in Excel 2000. A custom menu bar opens a form that contains a listbox and two control buttons. One of the control button's function is to close the form. The code used is simply unload frmJob(name of form). It takes two attempts to close this form. It appears when the form is loaded it is being loaded twice. If I walk through the code it behaves the way intended. Why would the form be loaded twice. The code to load the form is as follows: Function OpenFrm() Dim rng As Range Dim ws As Worksheet Set ws = Sheet4 Set rng = ws.Range("b8") With rng Do Until rng.Value = "" frmJob.lstJob.AddItem rng.Value Set rng = rng.Offset(1, 0) Loop End With 'Load frmJob frmJob.Show End Function any help is appreciated . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms | Excel Discussion (Misc queries) | |||
forms | Excel Worksheet Functions | |||
Forms | Excel Discussion (Misc queries) | |||
forms | Excel Discussion (Misc queries) | |||
Pop Up Forms | Excel Discussion (Misc queries) |