bluetide76
10-24-2008, 03:28 PM
I'm still new to excel vba but I was wondering if it is possible to create a table based on partial user input as well as my own setup. Odd way to word it exactly but to specify I mean that say I wanted to set up a table that will have a certain number of rows and columns based on what the user inputs. Then beyond that I want to have titles and headers that will adjust to this incrementation. I dont want the table to calculate anything or do that pivot formats of functions with list data. I just want the user to be able to specify (ex. 8 bags, 2 stores) and then it would make my prebuilt table with 8 rows naming bag1 bag2... and then the header store 1 store 2.
Also after this I was wondering if there is a way to manipulate certain cells to become dropdown boxes for the choices of <,>,=,<=,>=
Any help would be great.
This is aimed to basically grab basic user input to create a proper sized table with certain headers and row names and then the user can input further data into the fields I specify in order for me to use that in late calculations.
Also after this I was wondering if there is a way to manipulate certain cells to become dropdown boxes for the choices of <,>,=,<=,>=
Any help would be great.
This is aimed to basically grab basic user input to create a proper sized table with certain headers and row names and then the user can input further data into the fields I specify in order for me to use that in late calculations.