Solved

Building Forms in Microsoft Excel

Posted on 2012-04-11
1
406 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

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.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

813 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

13 Experts available now in Live!

Get 1:1 Help Now