I have a Master UserForm with 3 command buttons - Next , Review , Create. I also have several textboxes and comboboxes on this UserForm. One of the ComboBoxes is populated with Numbering from 1 - 65534. Here is my two part question: (I hope I explain this well enough and yes, it all needs to work together) 1) How can I save a copy of the values entered in the textboxes based on the Number? (i.e. Form #1 has information a,b,c from textboxes 1,2,3 and Form #x has information x,y,z from textboxes 1,2,3). 2) How can I create a new workbook for each Form Number? (i.e. Form 1 gets Workbook 1, Form 2 gets Workbook 2, Form 3 gets Workbook 3...... Form 5000 gets Workbook 5000)
I have not started any code as of yet cause I am not really sure where to begin. I am fairly new to VBA. If I can offer any more information, please do not hesitate to contact me. Thanks in advance for all the help. Sorry for making this a two part, but it seems to be all related. Hope everyone understands.
This message was edited by K_Man95 on 2002-09-09 13:52
I have not started any code as of yet cause I am not really sure where to begin. I am fairly new to VBA. If I can offer any more information, please do not hesitate to contact me. Thanks in advance for all the help. Sorry for making this a two part, but it seems to be all related. Hope everyone understands.
This message was edited by K_Man95 on 2002-09-09 13:52