Excel Question Window

[mph2010]

Not sure if anything like this can be done but here's the info....


Each cell in Column E has a scroll-down menu w/ several options. When the last option, "Complete", is selected I want the user to be asked "by whom" and to select a name to be put into the corresponding cell in Column F. So is it possible to prompt the user to select a name after they have selected "Complete" ? I was thinking of a question window popping up or maybe a notifcation to select a name from the given options. Does this make sense? And is this possible? Thank you for any help.

 

[Trevor G]

You could create a userform and then the form can pop up when a value has been selected and in the userform you can specify a list of names and once selected it can place in the name where every you need it.

Do you know about userforms?

 

[mph2010]

I don't know about userforms. Novice over here. Any brief info you can provide would be great. Thank you!

 

[Trevor G]

Do you have access to YouTube they have loads of tutorials about userforms on there if you do then google (or search) for creating a userform on YouTube, it will help you watch then apply.

Here is a link to start you off.

http://www.youtube.com/watch?v=5PN7lWJSobQ

 

[mph2010]

I do. That link looks great. Thanks so much for your help, Trevor.

 

[Trevor G]

I hope it helps finding a solution for you.