Hey
There are a few things i would like to create on my spreadsheet howeve
i have an idea of how to do it but dont know how can anyone help? th
things a

1. If i have a table of pupil data and there is a command button name
Add new person, when you click on this button a form appears once yo
filled in the information on this form and clicked another button name
OK the new information will automatically be listed with the the othe
data of people as a new record.
HOW IS THIS DONE?

2. If you have data of students and you want to search through it, I
there a way where you could type in details you are looking for of
certain person on a form on another sheet in excel and then select
command button named SEARCH and it will find it for you?

HOW IS THIS DONE? Need Macros, forms??? lookup???

thank you :confused

--
Message posted from http://www.ExcelForum.com

totally,

Do 1 something like this:
Open a workbook. Press Alt+11. Add a "userform" to your project. Put a
button on it. Change Caption to "OK". Put text boxes on userform for input.
Double-click the OK button. In the the click event handler (called like
Command1_Click()), place code that wites the textbox contents to the
worksheet; something like Range("A1").Value = TextBox1.Text,
Range("B1").Value = TextBox2.Text, etc.. Add a button to the worksheet.
Right-click, View Code. Add (like) Userform1.Show to click event handler.
Try it.

Use what you learn in 1 to do 2.

Consider Range("A1:Z26").Find(.... Look up Find method of Range object.

Bob

"totallyconfused " wrote in
message ...
Hey
There are a few things i would like to create on my spreadsheet however
i have an idea of how to do it but dont know how can anyone help? the
things a

1. If i have a table of pupil data and there is a command button named
Add new person, when you click on this button a form appears once you
filled in the information on this form and clicked another button named
OK the new information will automatically be listed with the the other
data of people as a new record.
HOW IS THIS DONE?

2. If you have data of students and you want to search through it, Is
there a way where you could type in details you are looking for of a
certain person on a form on another sheet in excel and then select a
command button named SEARCH and it will find it for you?

HOW IS THIS DONE? Need Macros, forms??? lookup???

thank you


---
Message posted from http://www.ExcelForum.com/