Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2097
  • Last Modified:

prompt user with dropdown list in Excel VBA assign value to variable for later use in code

prompt user with dropdown list in Excel VBA to select a month (January, February, etc.) assign value to a variable for use elsewhere in the code... thanks.
0
newknew
Asked:
newknew
1 Solution
 
Robberbaron (robr)Commented:
I believe you can only do this by creating a form sheet within your workbook.

from code you can open the form  UserForm1.Show

http://www.excel-vba-easy.com/vba-userform-excel-vba.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now