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
In userform
i have a drop down by the name of ComFruit
under that there are fruits name like Apple1, Apple2 and Orange1 and orange2
also having two checkbox by the name of coapple and coorange
there are four workbook embed in workwook. object 1, object 2 and object 3 and Object 4
I want if coapple (checkbox) is checked then ComFruit value is apple 1 and apple2 should be visible and if user select apple 1 and click on generate button. Generate button name is ComGeneFruit, then object 1 workbook should open. same apply for apple2 to open object 2
f coorange (checkbox) is checked then ComFruit value is orange1 and orange2 should be visible and if user select organge1 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
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
In userform
i have a drop down by the name of ComFruit
under that there are fruits name like Apple1, Apple2 and Orange1 and orange2
also having two checkbox by the name of coapple and coorange
there are four workbook embed in workwook. object 1, object 2 and object 3 and Object 4
I want if coapple (checkbox) is checked then ComFruit value is apple 1 and apple2 should be visible and if user select apple 1 and click on generate button. Generate button name is ComGeneFruit, then object 1 workbook should open. same apply for apple2 to open object 2
f coorange (checkbox) is checked then ComFruit value is orange1 and orange2 should be visible and if user select organge1 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