Help in USerform

[Rahulwork]

Hello Everyone,

I am working on a Userform and need your urgent help on the same.

Purpose of this userform to open relevant workbook which are attached in workbook as Object. I have to hide that sheet and sheet name is objectsss


In userform


I made on combo box and gave name - ComFruit

Under that i added items via UserForm_Initialize()

comComfruit.AddItem "Apple1"
comComfruit.AddItem "Apple2"
comComfruit.AddItem "Apple3"
comComfruit.AddItem "Apple4"


Also having two option buttons with the name CBXApple and CBXOrange


there are four workbook embed in workbook. object 1, object 2 and object 3 and Object 4


I want if CBXApple (optionbutton) is checked then ComFruit should show only apple 1 and apple2 and if user select apple 1 and click on generate button. Generate button name is ComGeneFruit, then object 1 workbook should open which is embed under sheet named objectsss. same apply for apple2 to open object 2




for CBXApple(optionbutton) is checked then ComFruit should show only orange1 and orange2 only. if user select orange1 and click on generate button. Generate button name is ComGeneFruit, then object 3 workbook should open. same apply for orange2 to open object 4

i think should be done by OpenEmbeddedWB()


let me know if you need any further information


Please help

 

[Grand]

Dear Rahulwork
I believe you have asked this question many times and each time you called your buttons differet things.