Excel 2003- Creating an Interactive Form

[silcox1984]

I am looking to create an interactive form using Excel 2003.

If at all possible, I am looking to avoid using VBA or macros.

My tool needs to be multifunctional.

I want to be able to input a Location, and receive all the information I can about that location. I also want to be able to enter my name and find out information to see if I have all the information required for that location.

For example: Lets say my location I pick (could be from a drop down) is Orlando, FL

I want a bunch of data to display (Shorts, T-Shirt, Sunglasses)


Next: I want to be able to pick my name: Silcox1984

I want data to display that I have Shorts and T-Shirt.

The implication here is that I am missing sunglasses.



I have the data required in order to make this tool, and I am fully prepared to create Tab after Tab of this information. I would just like to know how I can make this work?

 

[MrKABC]

I don't think you will be able to do this in Microsoft Excel. You really should consider Microsoft Access. A database application sounds like what you need.

You know the saying, "Use the right tool for the right job"?

Good luck!

 

[silcox1984]

Hi!

Thank you for your input. I have actually been tasked to use anything but MS Access. I am hoping to keep this Excel based...but if you have any other suggestions; that would be greatly appreciated!


Thank you,

 

[Andrzejek]

You CAN do that in Excel (I would opt for some kind of database, but ....) But I think you need to use VBA if you want "to create an interactive form using Excel 2003."

Since you claim to "have the data required in order to make this tool", you can pick the range with all of your locations and populate a drop-down combo on your UserForm (in Excel VBA). Then compare it with the information selected for your user ID and find the difference (find your sunglasses).

You don't need to "create Tab after Tab ", I just don't know how you can do it with "avoid using VBA or macros."

Have fun.

---- Andy

 

[silcox1984]

Thank you Andy

Perhaps my avoidance of VBA or Macros comes from a lack of understanding.

Could you please guide me through this?

Here is my sample data:

Site(s):
Orlando
San Francisco


Orlando Site Requirements:
Shirt
T-Shirt
Sunglasses

San Francisco Site Requirements:
Passport
Poncho
Umbrella


Traveler:
Silcox1984

Traveler Possessions:
Shirt
T-Shirt



I want to compare Site Requirements and Traveler Possessions to show that Silcox 1984 is missing requirements for both Orlando and San Francisco.


I will have multiple sites with multiple site requirements.

I will also have multiple Traveler's with lots of possessions.


I have created validation lists to separate the site information from each other. How can I create this macro using Validation Lists?


Thanks again.