Hi All,
I’m in serious confusion why the controls are not working in the multipage which is interested in excel sheet. After clicking design mode, I have righted clicked and able to get the option to edit the multipage details. However, none of the controls like check box, command button, radio button have the “View Code” option enabled. I can able to change the text on them but not able to right the code like how I use to right it in forms.
For Example, in forms I have button named “Submit” which will take have the code like msgbox ”Form Submitted”. When I click the submit button after running the form, ideally a message box will get displayed with the text “Form Submitted”. I’m unable to perform the same task in the multipage control which I inserted in excel sheet. L
Could someone please help on this? Thanks in advance.
Regards,
Dheepak
I’m in serious confusion why the controls are not working in the multipage which is interested in excel sheet. After clicking design mode, I have righted clicked and able to get the option to edit the multipage details. However, none of the controls like check box, command button, radio button have the “View Code” option enabled. I can able to change the text on them but not able to right the code like how I use to right it in forms.
For Example, in forms I have button named “Submit” which will take have the code like msgbox ”Form Submitted”. When I click the submit button after running the form, ideally a message box will get displayed with the text “Form Submitted”. I’m unable to perform the same task in the multipage control which I inserted in excel sheet. L
Could someone please help on this? Thanks in advance.
Regards,
Dheepak