Ok I have a userform with 10 control buttons each control button will make a frame visible the user from has 13 frames in total but only 10 will be effected by the control buttons. The 10 frames will allow the user to enter specific data. It sounds simple but here is the issue.
When the control button1 is clicked I need the corresponding frame let’s say frame1 to be visible and enabled, so for the control buttons Click I have
frame1.Visable = True
frame 1.Enable = True
That I figured out, and if I click control button 2, frame 2 becomes visible which is want I want. What is stumping me is if I click control button 1 again, frame 2 stays visible and on top.
I don’t want to have to enter code for all 10 control buttons I need away either using class modules so that when a control button is clicked that frame becomes visible and enable while the other 9 frames are hidden and not enabled while the other 3 frames are always visible. I am not a programmer and I am trying to teach myself how to do this. I am not looking for someone to write it for me but more or less to give a push in the right direction.
Am I right about using a class module to control the 10 buttons and what happens when they are clicked. Where can I find the syntax for the code I need to be using
I figure somehow when a button is clicked it will have to register as a value so that that value can be placed in the class module and that value corresponds to a frame while the rest of the code tell the other frames to be hidden other than the 3 constant frames..
Any help would be great
Thanks in advance
When the control button1 is clicked I need the corresponding frame let’s say frame1 to be visible and enabled, so for the control buttons Click I have
frame1.Visable = True
frame 1.Enable = True
That I figured out, and if I click control button 2, frame 2 becomes visible which is want I want. What is stumping me is if I click control button 1 again, frame 2 stays visible and on top.
I don’t want to have to enter code for all 10 control buttons I need away either using class modules so that when a control button is clicked that frame becomes visible and enable while the other 9 frames are hidden and not enabled while the other 3 frames are always visible. I am not a programmer and I am trying to teach myself how to do this. I am not looking for someone to write it for me but more or less to give a push in the right direction.
Am I right about using a class module to control the 10 buttons and what happens when they are clicked. Where can I find the syntax for the code I need to be using
I figure somehow when a button is clicked it will have to register as a value so that that value can be placed in the class module and that value corresponds to a frame while the rest of the code tell the other frames to be hidden other than the 3 constant frames..
Any help would be great
Thanks in advance
