Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why is this code not working
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
|
|||
|
|||
Why is this code not working
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
|
|||
|
|||
Why is this code not working
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 | |
|
|
Similar Threads | ||||
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 |