Entering variable data into a userform

[towners]

Hi,

I need to collect downtime time data from several lines. There can be more than one reason for downtime and I want to be able to collect this from a single list of codes in a userform where the user simply enters the number of minutes against a particular code and this then poulates my spreadsheet.

Can anyone give me any pointers on how to do this?

Thanks

Paul

 

[Smitty]

Are you looking for overall pointers on User Form design? If so, check out: http://www.contextures.com/xlUserForm01.html

There's another section on using Combo Boxes in User Forms, which might be handy to populate your codes.

HTH,

 

[towners]

Hi, thanks for that.

I've had some success getting data from a userform into my spreadsheets, what I'm stuck on is presenting the options (from a listbox?) and getting the user just to enter minutes against one or many items then hitting "OK" and populating the spreadsheet to save time. I've had a look at the contextures page but it doesn't really help me.