DB73
Board Regular
- Joined
- Jun 7, 2022
- Messages
- 102
- Office Version
- 365
- 2021
- 2019
- 2016
- 2010
- 2007
- Platform
- Windows
- Mobile
- Web
Ive made a form with several comboboxes en textboxes
if i populate these i let a "command button"write the text/value to my dumpstats sheet.
but sometimes i forget to populate 1 of these boxes.
is it possible to add some vba to that command button, before it sends all value to the dumpstats sheet, too check if 1 or more of the boxes are empty and then color the empty red so i can fill them in.
after completion to let it write to my dumpstats sheet.
at first i made it just with a message boxes, thats shows "everyting filled in correctly ?", but that isnt actulay checking and sometime is just say yes , and then i get some faults.
thanks in advance
if i populate these i let a "command button"write the text/value to my dumpstats sheet.
but sometimes i forget to populate 1 of these boxes.
is it possible to add some vba to that command button, before it sends all value to the dumpstats sheet, too check if 1 or more of the boxes are empty and then color the empty red so i can fill them in.
after completion to let it write to my dumpstats sheet.
at first i made it just with a message boxes, thats shows "everyting filled in correctly ?", but that isnt actulay checking and sometime is just say yes , and then i get some faults.
thanks in advance