VB Duplicate & Rename Sheets

[Rioulol]

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.

 

[My Aswer Is This]

When you say:
I'm looking to have a form with a Textbox on it

Do you mean a: "UserForm"

If not, what is a "Form"?

And you said:
Duplicate a form named "Company Settings

What is a form???