Solved

Building Forms in Microsoft Excel

Posted on 2012-04-11
1
404 Views
Last Modified: 2012-06-27
Hi, I have a spreadsheet - the data is in a table like format - consisting of Customer data, products and prices.  I want to add a control box where the user can select one of the customers from the spreadsheet and another form is populated with the selected data.  

Attached is a mock-up.
Excel-Form-Example.jpg
0
Comment
Question by:Marilync1266
1 Comment
 
LVL 41

Accepted Solution

by:
dlmille earned 500 total points
ID: 37836444
Here's a tip on adding controls that will help the user select from a list.  Code can be written against making changes in these controls.

http://blog.contextures.com/archives/2010/11/10/combo-box-drop-down-for-excel-worksheet/

If you upload a mock example of what you want, it will be easier to help you further.

Cheers,

Dave
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now