Answered by:
script to list down values from an excel sheet and asks the user to select the values

Question
-
Hi,
I need to write a script that lists down values present in an excel sheet.The user need to select one or more values that are listed in the UI.Please help
- Moved by Rich Prescott Saturday, February 11, 2012 2:12 AM Excel dev (From:The Official Scripting Guys Forum!)
Thursday, February 9, 2012 7:09 AM
Answers
-
Hi,
I need to write a script that lists down values present in an excel sheet.The user need to select one or more values that are listed in the UI.Please help
If you just type the values into Excel they can be easily selected at any time using the mouse. You don't need a script to do this.
What is supposed to happen when a value is 'selected'?
¯\_(ツ)_/¯
- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, March 27, 2012 3:00 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Monday, April 9, 2012 3:21 PM
Thursday, February 9, 2012 4:35 PM
All replies
-
Thursday, February 9, 2012 7:24 AM
-
The values accessed from the excel sheet should be listed down in a user interface and the user needs to select one or more values from them.Thursday, February 9, 2012 7:49 AM
-
That sounds like application development. This forum is aimed at adminstrative scripting, mainly command line, VBS, or Powershell.
It seems to me that you should be writing a custom form in VBA.
Grant Ward, a.k.a. Bigteddy
Thursday, February 9, 2012 8:37 AM -
Hi,
I need to write a script that lists down values present in an excel sheet.The user need to select one or more values that are listed in the UI.Please help
If you just type the values into Excel they can be easily selected at any time using the mouse. You don't need a script to do this.
What is supposed to happen when a value is 'selected'?
¯\_(ツ)_/¯
- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, March 27, 2012 3:00 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Monday, April 9, 2012 3:21 PM
Thursday, February 9, 2012 4:35 PM -
Hi,
Please read the following:
Bill
Friday, February 10, 2012 12:01 AM -
Thanks a lot guys..Friday, February 10, 2012 5:13 AM