Advertisement

02.23.2007 at 09:28AM PST, ID: 22409568
[x]
Attachment Details

Excel / VBA Macro to Insert Value from Pop-up

Asked by aaron_karp in Spreadsheet Software, Microsoft Excel Spreadsheet Software, Software Office Suites

Tags: , , , ,

Hi experts,

Is there any way I could create a VBA macro that when run would display a pop-up list of values of which one could be selected and inserted into the current cell?

For exmaple

Cell 1: Empty

Run Macro - brings up pop-up list:
Option1
Option2
Option3
Option4
Option5

Select Option3:

Cell 1: (Option3)

Is this at all possible? Can you give me a solution?

Thanks.
-- MattStart Free Trial
 
Keywords: Excel / VBA Macro to Insert Value fro…
Title
1 Extract letters from mixed string (Exc…
2 VBA Macro Error
3 Cell Format via VBA
4 Count cells if ... VBA
5 Excel Macro
6 Updating Graph using a VBA macro in …
 
Loading Advertisement...
 
[+][-]02.23.2007 at 09:33AM PST, ID: 18597653

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.23.2007 at 09:40AM PST, ID: 18597698

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.23.2007 at 09:42AM PST, ID: 18597713

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.23.2007 at 09:44AM PST, ID: 18597736

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.23.2007 at 09:51AM PST, ID: 18597790

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.23.2007 at 09:57AM PST, ID: 18597846

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Spreadsheet Software, Microsoft Excel Spreadsheet Software, Software Office Suites
Tags: excel, vba, macro, insert, value
Sign Up Now!
Solution Provided By: R_Rajesh
Participating Experts: 3
Solution Grade: A
 
 
[+][-]02.23.2007 at 09:59AM PST, ID: 18597857

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.23.2007 at 10:17AM PST, ID: 18598007

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.23.2007 at 10:20AM PST, ID: 18598024

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32