Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Forms
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Forms
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Forms
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Forms in Excel | Excel Worksheet Functions | |||
Creating excel forms | Excel Discussion (Misc queries) | |||
creating fax forms | Excel Discussion (Misc queries) | |||
Creating "records" in Forms | Excel Discussion (Misc queries) | |||
Creating forms in excel | Excel Discussion (Misc queries) |