Entering data among multiple rows and columns.

[mpopkowski]

What is the best approach using a userform to accomplish this. My spreadsheet looks something like this:

Description---Control----Keypad----Transformer----Costs

Closet-----------1-----------1-------------1----------$210.00
Garage----------------------1-------------------------$ 69.00
Bedroom--------------------1-------------------------$ 69.00


Userform would ask for a description and then ask if any of the following apply. This would continue until the user had entered in all the needed information.

Thanks,
Mark

 

[mpopkowski]

bump

 

[BrianB]

I don't think we understand what you want. Can you give an example of user input and the result you expect ?

 

[mpopkowski]

The user would be asked for a description and then asked what equipment would be installed for that area. ie.
Please enter a description - User enters information
What equipment will you be installing - User only needs to put a 1 or an X by the equipment to be installed.
I hope this helps.

Thanks, for responding
Mark

 

[SydneyGeek]

This post
http://www.mrexcel.com/board2/viewtopic.php?t=77855&highlight=
shows how to create controls on a userform, then push that data to a worksheet when finished.

Denis