Using Excel 2007. Want to use a combobox on a worksheet for users to choose a month (January, etc.). Their choice should be stored as a text variable "January" for use in an existing formula in the same worksheet. The formula should execute when they make their choice from the list. Can someone help me construct the solution using VBA? I'm a newbie with VBA.
Thank you, experts!