PDA

View Full Version : Command button to go to another sheet with drop button click



aiman015
05-17-2020, 11:23 PM
hello guys
i have a hyperlink button for each item written (electricity, water, co2):
26696

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
05-18-2020, 12:02 AM
Hi aiman015 (http://www.vbaexpress.com/forum/member.php?78385-aiman015)!
Something like below:

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