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
.
|