Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form VBA
correct me if i am wrong but you have OpenPS001F to be Visible = FALSE if
Mycell < 50??? "Mark J" wrote in message ... cell value is less than 50, so why does the code not fire? "William Horton" wrote: I assume you have double checked that MyCell contains a value that is greater than 50... "Mark J" wrote: I have the following code: Private Sub UserForm_Activate() Me.OpenPS001.Visible = False Me.OpenPS001F.Visible = False MyCell = Worksheets("PS001").Range("d9") If MyCell 50 Then Me.OpenPS001.Visible = False Me.OpenPS001F.Visible = True Else If MyCell < 50 Then Me.OpenPS001F.Visible = False <=========== Change to True Me.OpenPS001.Visible = True End If End If End Sub on open, OpenPS001F should appear , but does not, any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
Pass variable from form to form to form | Excel Programming | |||
Strange issue freezing parent form when unloading a child form | Excel Programming | |||
Transfer data to form from Excel range upon loading of form. | Excel Programming | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming |