Hi,
I have a spread sheet that has 2 work sheets 'Breach Form' and 'Register'.
What i have tried to create is a Form that can be used to update the Register. I have created the form by using text boxes.
I have now come to the point of creating the VBA / Macro that i can assign to a button that will take the data out of the text boxes and insert the data into the register (into the appropriate cells) then delete the content from the text boxes.
I also require a refresh/clear button that can be used to delete the information from the text boxes in the form if a mistake is made.
can some please provide support in this as my VBA / Macro skills are very limited.
Kindest Regards,
Ben
I have a spread sheet that has 2 work sheets 'Breach Form' and 'Register'.
What i have tried to create is a Form that can be used to update the Register. I have created the form by using text boxes.
I have now come to the point of creating the VBA / Macro that i can assign to a button that will take the data out of the text boxes and insert the data into the register (into the appropriate cells) then delete the content from the text boxes.
I also require a refresh/clear button that can be used to delete the information from the text boxes in the form if a mistake is made.
can some please provide support in this as my VBA / Macro skills are very limited.
Kindest Regards,
Ben