Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I keep getting an error on a UserForm, named UserForm1. Microsoft Forms 2.0
is checked off as a Reference. The code is extremely simple: Sub OpApp() ActiveWindow.WindowState = xlMinimized UserForm1.Show End Sub It keeps failing on this line: UserForm1.Show Ive worked with hundreds of different UserForms before; I cant figure it out. Could the UserForm somehow get corrupted? This is the second time that Ive tried this; with a fresh UserForm. What could cause this kind of behavior? All code behind UserForm is commented out... 'Private Sub cmdNewPT_Click() 'Dim C As MSForms.Control 'For Each C In Me.Controls 'If TypeOf C Is MSForms.TextBox Then 'C.Text = "" 'End If 'Next C 'End Sub Any thoughts? Thanks, Ryan--- -- RyGuy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
scope of private function called from UserForm fails | Excel Programming | |||
Really strange!! Switch/Open code fails occasionaly?! | Excel Programming | |||
Workbooks.Open Fails | Excel Programming | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
Autorefresh Fails on Open | Excel Discussion (Misc queries) |