Command button to go to another sheet with drop button click

[aiman015]

hello guys
i have a hyperlink button for each item written (electricity, water, co2):
R858b7j.jpg

When the user choose (co2, electricity or water) in the scroll-list, and click "validate" button it will bring up to worksheet with the same name
How can i change this to a command button in my VBA userform!!

[大灰狼1976]

Hi aiman015!
Something like below:

sub test
sheets(combobox2.value).activate
end sub