Forms and WorkSheets
Hi All,
I have a user form wherein I set the variable of a global variable based on the selection of certain radio buttons. Based on the value chosen I have command buttons selected and deselected in the worksheet. But after I hide the form and activate the sheet, the control is not transferred to the worksheet_activate() method where the functionality has been handled. Is there something that I am missing? Thanks in advance, Haarish. |
Forms and WorkSheets
Hello Haarish,
You say "after I hide the form and activate the sheet, the control is not transferred to the worksheet_activate() " . Is the particular worksheet already the ActiveSheet. By this I mean the worksheet that you can see when the Userform is hidden. If so then you might have to do something like this to fire the Worksheet_Activate event. 'Following code in Userform module. Private Sub CommandButton1_Click() Me.Hide 'Hide userform Sheets("Sheet2").Activate 'Activate another worksheet Sheets("Sheet1").Activate 'Activate the required worksheet. End Sub If the above does not answer your question then perhaps you can share some of your code. -- Regards, OssieMac "Haarish" wrote: Hi All, I have a user form wherein I set the variable of a global variable based on the selection of certain radio buttons. Based on the value chosen I have command buttons selected and deselected in the worksheet. But after I hide the form and activate the sheet, the control is not transferred to the worksheet_activate() method where the functionality has been handled. Is there something that I am missing? Thanks in advance, Haarish. |
All times are GMT +1. The time now is 01:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com