create userform

I want to create a userform for filling in the box in my example. Cells B3:I3 use a dropdown. All the other white cells could possibly contain numbers.
Do I have to create a textbox for each white cell? Or can I recreate this table in the userform and have people key it there? In other words whats the best to turn this into a userform.

thanks.

Originally Posted by erock24

I want to create a userform for filling in the box in my example. Cells B3:I3 use a dropdown. All the other white cells could possibly contain numbers.
Do I have to create a textbox for each white cell? Or can I recreate this table in the userform and have people key it there? In other words whats the best to turn this into a userform.

thanks.

Hi,

Personally I'd use the Activex forms in the Visual Basic Environment (VBE), to recreate this table. The descriptions would be Label boxes, and drop down cells would be ListBoxes which would be populated by pointing their .RowSource property to your department list range.

The $ cells could be Comboboxes or TextBoxes with their .ControlSource property pointing to an underlying Excel range. The red total cells would in turn be text boxes but with their Control Source pointing to the =Sum() totals in the underlying Excel range. Hence as you complete the combo/text boxes, with values, the total text boxes would be updated via the Control Source.

HTH

Originally Posted by royUK

Why do you need a UserForm? The sheet can be used as a "form" as it is.

I did wonder too.

Since the OP specifically asked for this, I assumed it was because they wanted it for presentational purposes, or indeed to keep the user away from the Excel end of the business.

Rgds

This table is part of a sheet that gets filled out via userform. Right now it is the only section that isn't built into the userform. Right now after the user fills out the rest of the info on the userform I direct them to this table in the sheet to complete. Alot of times it doesn't get completed. But if I had it in a Userform I could restrict the user and make them do it.

Richard I am going to try to setup the form via your description. I may have a followup question or two. Thank you for your time and help.