teamhog
04-06-2016, 12:04 PM
I have a worksheet where a client is asked to enter daily data on a regular basis (every week or two).
The sheet is limited to the current year only (so it'll either have 365 or 366 rows).
The data is similar to this:
Date
TonsOfProduct
Color
GasUsage
01/01/2016
10,001
Y
255,666,666
01/02/2016
10,015
N
120,120,222
...
...
...
...
12/31/2016
10,020
Y
101,222,131
My plan is to create a userform where the entire contents of the year are loaded up on the form initialization.
Other than creating the text boxes by hand, is there another way/method to do this?
I looked at loading it up into a sheet control or a flex grid control but some of the computers that this would run on don't have those controls.
The sheet is limited to the current year only (so it'll either have 365 or 366 rows).
The data is similar to this:
Date
TonsOfProduct
Color
GasUsage
01/01/2016
10,001
Y
255,666,666
01/02/2016
10,015
N
120,120,222
...
...
...
...
12/31/2016
10,020
Y
101,222,131
My plan is to create a userform where the entire contents of the year are loaded up on the form initialization.
Other than creating the text boxes by hand, is there another way/method to do this?
I looked at loading it up into a sheet control or a flex grid control but some of the computers that this would run on don't have those controls.