Solved

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

Posted on 2013-01-23
1
1,554 Views
Last Modified: 2013-07-21
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
Comment
Question by:newknew
1 Comment
 
LVL 32

Accepted Solution

by:
Robberbaron (robr) earned 500 total points
ID: 38813893
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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel VBA User Form Help 21 29
Alphabetical Order for Letters 2 21
Excel formula Sumif not working 4 28
Excel Question 17 15
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question