Creating a user interface for an excel file.

**hnkkseanH** · 06-12-2008, 01:00 AM

hello all,

I have been tasked by the company I work for to come up with a simple to use interface that can be used by someone with little understanding of excel to set the autofilters to certain settings.

So here is what I have:

2 sheets (each with the same number of columns but different data which corresponds to good and no-good)

Each column has an autofilter but only two on each sheet need to be set.

One filter controls valve type (of which there are 10) and the other controls running condition (startup and normal)

Now my employer wants something that is basically idiot proof so that someone can simply open up the excel file, input the valve type and running condition, and be rewarded with only the corresponding data and charts. Now the filters are already in place, the charts already exist and the only thing left is the user interface.

Anyone got any ideas? Help would be much appreciated.
Note, I don't have any understanding of VBA but I do know a bit of FORTRAN if that helps.

Sean H

**Leith Ross** · 06-12-2008, 03:46 AM

Hello hnkkseanH,

It would be best to submit your workbook for review. Seeing the data and the layout are key to developing an user interface. Be sure to remove any confidential material before posting your workbook. The maximum allowable upload file size is 100 KB.

Sincerely,
Leith Ross

**hnkkseanH** · 06-12-2008, 04:05 AM

Well I hate to say it but the file is 30 mb, without any of the data. I am not sure why this is and I would imagine that it should be much smaller. But either way there is no way for me to upload it for you to look at it.

The basic layout consists of:

6 charts (scatterplots) made up of data from the two sheets
2 Sheets. one with the good data and one with the bad (differentiated on the charts)

the two charts have the same like 40 columns and headings. Two of which need filter controls. These being Valve Model and Test Running.

I believe that I need help in understanding VBA but I don't know where to input code nor do I no anything about coding in it.

The UI just needs to control the filters for the two columns on each of the two sheets.

**hnkkseanH** · 06-12-2008, 04:09 AM

sorry double post

**hnkkseanH** · 06-12-2008, 08:21 PM

I have just been introduced to the UserForm command and this seems to be a relativly good first step. It seems possible to create a good UI from this. Now the clincher will come from the ease or difficulty of using it to control the filters.

I am sorry that I am so in the dark about this. I just don't really want to go around spending money on the training manuals when all I need help on is this one thing.

If anyone has a problem in Aerospace Engineering then maybe I can repay with a little knowledge

**hnkkseanH** · 06-16-2008, 04:28 AM

Well, after doing some digging around I have found this tutorial type excel file. Now I have figured out how to implement the VBA code into something i can use (and making it cover two sheets) What I can't seem to do is figure out how to create the button on my worksheet (I can only work with this sample here, can't apply it to my wksht).

please take a look and let me know what you think.