beginner_2win
New Member
- Joined
- Sep 6, 2006
- Messages
- 1
Hi all,
How do you create a button in excel 2004 for a macro that will take in a variable from the user and output the result? For example, I have a worksheet with all the information such as, Date, School, Ambassador, Student, First Name, Last Name.,etc. Basically what I want to do is have the user input the the school name or date or ambassador and the search result should spit all the relevant information on the search on a New worksheet.
I'm thinking about having a menu box with opiton to select the crietera.
For Instance...
Ambassdor
Date
School
Student
So, if a user select "Ambassdor" he/she can then enter the value like "John" and do a search and spit out all the relevant info in a New Work sheet.
Please Advise,
Beginner
Thanks,
Beginner
How do you create a button in excel 2004 for a macro that will take in a variable from the user and output the result? For example, I have a worksheet with all the information such as, Date, School, Ambassador, Student, First Name, Last Name.,etc. Basically what I want to do is have the user input the the school name or date or ambassador and the search result should spit all the relevant information on the search on a New worksheet.
I'm thinking about having a menu box with opiton to select the crietera.
For Instance...
Ambassdor
Date
School
Student
So, if a user select "Ambassdor" he/she can then enter the value like "John" and do a search and spit out all the relevant info in a New Work sheet.
Please Advise,
Beginner
Thanks,
Beginner