Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the code below on a command button on a form but the form just
blinks and nothing else happens. Private Sub cmdCancel_Click() Unload Me MilestoneForm.Show End Sub This is a similar code I used in another file and this works perfect. Private Sub cmdCancel_Click() Unload Me ufrmsiteInfo.Show End Sub Any ideas what is going on where? Thanks |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is the name of the form you are closing MilestoneForm ? As you are
re-initializing if it is. -- Regards, Nigel "Ayo" wrote in message ... I am using the code below on a command button on a form but the form just blinks and nothing else happens. Private Sub cmdCancel_Click() Unload Me MilestoneForm.Show End Sub This is a similar code I used in another file and this works perfect. Private Sub cmdCancel_Click() Unload Me ufrmsiteInfo.Show End Sub Any ideas what is going on where? Thanks |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Nigel. I just figured out that I was unload the form and showing at
the same time. MilestoneForm is the same form that is being Unload.Me "Nigel" wrote: Is the name of the form you are closing MilestoneForm ? As you are re-initializing if it is. -- Regards, Nigel "Ayo" wrote in message ... I am using the code below on a command button on a form but the form just blinks and nothing else happens. Private Sub cmdCancel_Click() Unload Me MilestoneForm.Show End Sub This is a similar code I used in another file and this works perfect. Private Sub cmdCancel_Click() Unload Me ufrmsiteInfo.Show End Sub Any ideas what is going on where? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Code Not Working | Excel Discussion (Misc queries) | |||
Code is not working....please take a look!!! | Excel Programming | |||
VB code is not working like it should | Excel Programming | |||
Code not Working - Help please | Excel Programming | |||
Code not working | Excel Programming |