Hi all,
I am reasonably new to VBA so any help would be appreciated. I'm using excel 2007 but I'd like the workbook to be compatible with older versions if possible.
I have a worksheet with a table for filling out employee data. I want users to be able to enter how many employees they have into a text box and for the table to then display that number of rows for them to fill out. The number of employees ("X") can vary from 1 to 100.
I was thinking the best way to do it would be to start with all the rows of the table hidden (i.e. rows 1:100) and then have some code that unhides rows 1:X whenever the number in the text box is changed. Trouble is I'm not sure how to do this.
Thanks in advance
G
Bookmarks