aiman015
05-17-2020, 10:28 PM
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
https://ibb.co/qJxcVYc26693
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
https://ibb.co/qJxcVYc26693