Hi
I have created this control panel in Excel vba and need some help to clean up the code and make it run more efficent.
What I would like to add is an error trap that will produce a warning box advising the user thay haven't selected a week or site also currently the program will write the default values to the workbook. I would like to set it so that if the user enters nothing then nothing (not even a blank space) is written to the work book.
Reason is that the user may only enter data for 1 day but the default data for all days is being written to the workbook which takes up unneccesary space.
Goal - Would like to show an error if WeekDD and SiteDD default values have not been changed and if TextBox1 or TextBox2 default values have not been been changed nothing is to be written to the workbook.
The TextBox default values are 0
WeeDD Default value is week
And SiteDD default value is Site
Code I have so far is:
Can anyone offer some guidance on how to achieve this?
I know I am asking lots of questions but I am new to creating forms in VBA. many thanks in advance.
Bookmarks