Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 1989) 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