I have a worksheet with two sheets (sheet1 and sheet2). I would like
to create a userform based on sheet1. The header columns and rows are
labels with values based on the values in sheet1. The grid is made up
of textboxes to input numerical values.
An example is at
http://sites.google.com/site/cavemansavant/Home

Sometimes there are 5 columns with 2 rows as shown, sometimes 12
column and 1 row. Just depends on sheet1.

Once the data is entered the data would be transfered to sheet2 once
you press the Submit button.
Reset would of course set all the textboxes to zero.

I understand the headers on Sheet 1 will be actual text rather than the
letters and numbers shown, but will there be values in the cells covered by
those headers and, if so, did you want those values shown in the TextBoxes
when the UserForm is first shown? If yes, did you actually mean you wanted a
Reset button to set the TextBoxes to zero or back to the initial values
shown in Sheet1? Can you tell us what the maximum number of column and rows
are (so we have some idea of the best way to approach creating the
TextBoxes)?

--
Rick (MVP - Excel)


"caveman.savant" <(E-Mail Removed)> wrote in message
news:959e3e44-6df7-4caf-a499-(E-Mail Removed)...
>I have a worksheet with two sheets (sheet1 and sheet2). I would like
> to create a userform based on sheet1. The header columns and rows are
> labels with values based on the values in sheet1. The grid is made up
> of textboxes to input numerical values.
> An example is at
> http://sites.google.com/site/cavemansavant/Home
>
> Sometimes there are 5 columns with 2 rows as shown, sometimes 12
> column and 1 row. Just depends on sheet1.
>
> Once the data is entered the data would be transfered to sheet2 once
> you press the Submit button.
> Reset would of course set all the textboxes to zero.

Yes the Header values will represent what is actually on sheet1.
Reset would actually set everything to zero, although it might be
interesting to see it set the values according to sheet1.
I see a maximum of 25 columns ever having to be generated. Numbers of
rows would never be more than 10.