Hi everyone, I was wondering if it was possible to create a userform that enters multiple data with one value being constant. For example I would like to have the Model# to be constant but would like to have three pages on the user form for that specfic Model #.
Each page represents that Model's 3 different sizes, also each page has 7 rows 3 cells of data.
Size 1, Size, Size 3 are the page headings in the Userform representing the three sizes of that Model#.
While as in each page the 3 cells represent: Qty (in Pieces), Length (in inches) and Width (in inches) times 7 rows.
I want this userform to both bring the 3 pages of stats (dimension sizes) by searching, but also edit and add new entries.
Another way to describe my userform would be to have baseball players stats. Having a userform that pulls data by name and it has 3 pages of data each for the three years. Each page only has 3 cell values hits, strikes, and runs, but seven rows,
Is this possible? If so could you recommend previous examples and/or VBA code?
Bookmarks