How to create a VBA form to match excel value to the name of the worksheet in the same workbook?

Posted by cody_q on Super User See other posts from Super User or by cody_q
Published on 2013-10-23T15:11:43Z Indexed on 2013/10/23 15:58 UTC
Read the original article Hit count: 211

I am working on a self created VBA form. It has submit button and takes in entries such as destination, timing and budget.

I have a excel worksheet named "bali". it consists of the destination's available airline,timing and budget.

I would like to create a method that could get the inserted destination eg. bali when the user clicked submit button and then match it to display and show the content of the worksheet named "bali" in another new sheet or a form.

Anyone could help me with this by providing a step by step code ?

Thank you.

Cody

© Super User or respective owner

Related posts about microsoft-excel

Related posts about microsoft-excel-2010