Hi there,
RE: VB Duplicate & Rename Sheets
I'm relatively new to VB, so you'll have to excuse my ignorance when it comes to some of the technicality behind it.
I'm looking to have a form with a Textbox on it, and when you press the submit button it will perform the following functions:
1. Check if the value of Textbox, on the form, exists anywhere in a table named 'tblCompanies' in a named ranged called 'rngCompanies' on a sheet named 'Company Data', if there is, show label (lblError) and stop the code, if not, then add a new record to the table which is the value of the Textbox on the form.
1. Duplicate a form named "Company" and rename the new sheet to whatever is in the Textbox field on the form.
2. Duplicate a form named "Company Settings" and rename the new sheet to what is in the Textbox field on the form + ' settings'.
If anyone could help me with this query, it is massively appreciated.
Thanks in advance.
RE: VB Duplicate & Rename Sheets
I'm relatively new to VB, so you'll have to excuse my ignorance when it comes to some of the technicality behind it.
I'm looking to have a form with a Textbox on it, and when you press the submit button it will perform the following functions:
1. Check if the value of Textbox, on the form, exists anywhere in a table named 'tblCompanies' in a named ranged called 'rngCompanies' on a sheet named 'Company Data', if there is, show label (lblError) and stop the code, if not, then add a new record to the table which is the value of the Textbox on the form.
1. Duplicate a form named "Company" and rename the new sheet to whatever is in the Textbox field on the form.
2. Duplicate a form named "Company Settings" and rename the new sheet to what is in the Textbox field on the form + ' settings'.
If anyone could help me with this query, it is massively appreciated.
Thanks in advance.