peteeide
03-31-2009, 04:28 PM
Hi, first time poster here.
I have one UserForm that calls another.
The first basically gets a few values then calls one of several others:
Private Sub EnterButton_Click()
...
Select Case ComponentCombo.Text
...
Case "Sub Population"
Unload XmlFormComp
XmlFormSP.Show (Modal)
...
End Select
End Sub
In XmlFormSP I have a RefEdit box. I also had a TextBox and had some code for it in App_SheetSelectionChange but pulled the TextBox and everything for it out to help troubleshoot. Also ShowModal = True in the XmlFormSP properties for the RefEdit.
Basically when I bring up XmlFormSP I can click on the RefEdit, the form collapses, I can select my range, click on the side button with the red arrow, am brought back to the form, then it's stuck. I can select a different range but I can't hit the submit button on the form or even close Excel without going throught the Task Manager.
I can worry about handling the data once I can actually push buttons on the form.
What am I missing please?
Thanks
I have one UserForm that calls another.
The first basically gets a few values then calls one of several others:
Private Sub EnterButton_Click()
...
Select Case ComponentCombo.Text
...
Case "Sub Population"
Unload XmlFormComp
XmlFormSP.Show (Modal)
...
End Select
End Sub
In XmlFormSP I have a RefEdit box. I also had a TextBox and had some code for it in App_SheetSelectionChange but pulled the TextBox and everything for it out to help troubleshoot. Also ShowModal = True in the XmlFormSP properties for the RefEdit.
Basically when I bring up XmlFormSP I can click on the RefEdit, the form collapses, I can select my range, click on the side button with the red arrow, am brought back to the form, then it's stuck. I can select a different range but I can't hit the submit button on the form or even close Excel without going throught the Task Manager.
I can worry about handling the data once I can actually push buttons on the form.
What am I missing please?
Thanks