Create an Excel Form with multiple drop down, lookup and calculation

[gimran]

Hello Everyone,

I need an Excel form which need to be accessed using different user ID and password. After login, some basic information of that user will appear along with a form.

The form will consist 4 fiels.
Field - 1: Input any number or text
Field - 2: a drop down list of text
Field - 3: a drop down list based on the selection of field 1.
Field - 4: a drop down list based on the selections of field 1 & field 2.
Submit button.

I also need a display box where, there will be two sections.
Section - 1: will show the sum of number of data entered.
Section - 2: will show the sum of predefined number which is the combination of field 1, field 2 & field 3.

Is it possible to make such files using Excel or VBA?

 

[ScottUlmer]

Sounds like you need to make a userform with a username and password, then you need a second userform to how down. You will get a toolbox which has all teh things you need. This is all pretty doable in VBA.