macro to make a window appear to get a first and last name and id number

0

Is it possible to make a macro that can have a window appear that asks a user for first name, last name, and id number? Like a kind of form but in one of those message windows. 

If that's possible I just need it to then put that information onto a personal data worksheet in the same excel file.

Answer
Discuss

Discussion

I agree with JonP, follow his link and make three prompts, one for each piece of data. That is the easiest way for you to do this and to maintain it in the future. If you get a little more versed in Excel, learn about userforms.
Also, you can style a worksheet to look like an input box and make that so there are just a few input fields on it and a button and when that button is clicked, the information will be entered onto another spreadsheet. That's not what you asked for but it would work.
For now, I'd say follow the link in JonP's post and then come back if you need more help and ask another question.
don (rep: 1247) Jul 1, '16 at 2:32 pm
Ok i will try this link from JonP and if it doesn't work try to do the worksheet thing and maybe come back to ask a question if I can't get it to work.
bcampbell Jul 1, '16 at 4:08 pm
Add to Discussion

Answers

0
Selected Answer

Check out Don's tutorial here, I think it may be what you want:

http://www.teachexcel.com/excel-tutorial/get-user-submitted-data-from-a-prompt-in-excel-using-vba-macros_1564.html

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login