• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Optional userform

Hi Everyone,

Can anyone please suggest if there is any way to change the userform on the basis of drop down selection.

Thanks and Regards,
Sandy
 
I have number of frames and 1 drop down....on the basis of drop down value I want frame1 to change...so for example if I select item1 then I should be able to see frame1 and its controls...if I select item2 in drop down then I should be able to see frame2 in place of frame1.....at 1 point of time only 1 frame should be visible......
 
Try this.

Taken simple example and tried!

Let me know any challenges.
 

Attachments

  • Combobox.xlsb
    23.8 KB · Views: 5
Hi Monty.....this is just changing the entire userform....I have let us say 3 frames in userform 1...which I want to be shown as per the dropdown value....rest of the controls remain same on the userform...so like in this example you have used userform1.show and userform2.show...instead can we write userform1.frame1.show or userform1.frame2.show etc...
 
Hello Sandy.
If u are really looking for a solution upload a file...We can't just guess.
 
Back
Top