vba code for an interface

[aiman015]

hello guys,
actually i am trying to make an interface for my workbook, and i started making it using vba, but i got stuck.
FIRST: in "what do you want to do" section i want to print two possibilities : consumption and KPI.
then if the user choose consumption,
-->the second part "what kind of energy"print 3 possibilities (electricity,water,gaz)
if else the user choose KPI,
--> "what kind of energy" print 3 other possibilities (KPI1,KPI2,KPI3)
Finally: each choice needs to be related to a worksheet, and send the user directly to that sheet named electricity or KPI1...etc by using the button "validate".
the problem is i tried so many codes, but it didn't work.
thanks a lot
g77BlRl.jpg

[Bob Phillips]

You say that you got stuck, so show us what you have so far, preferably a sample workbook.

[Fluff]

Cross posted https://www.mrexcel.com/board/thread...rface.1134415/

[Paul_Hossler]

Cross posted https://www.mrexcel.com/board/thread...rface.1134415/

Tsk, tsk -- Please read the FAQ link in my sig about cross posting rules

I'd just use radio buttons since the choices are so well defined

Capture.JPG


Working prototype POC using radio buttons in the attachment

[aiman015]

Thank you very much sir, u helped me a lot, im so sorry for the cross-posting.
it's my bad. trust me i won't repeat it again