I am busy creating a quote system, I have 4 different areas (HARDWARE, SOFTWARE, ACCESSORIES & PERIPHERALS) on the quote, where I want at least 1 item to be entered in any of the for 4 areas before the Accept button on a userform must work
I am using 2 combo box’s, One with the main list (Hardware, Software, Accessories, Peripherals). If I select Hardware in Combobox1 it shows all the Hardware in Combobox2, If I select software in combobox1, it shows all the software in combobox2 (Took me a while to figure out, but I got it to work 100%)
I have a button called “Add to quote”, and depending on the main list, the items will be added in the right areas on the quote.
My question is, that if no item is added, the Accept button must not work, by first check in the 4 cells listed below simultaneously. With the accept button I am using a unique quote number system. A record will be held of all the quotes entered, but I do not want to keep empty quotes
The first range of each area is
“S34” (HARDWARE)
“S62” (SOFTWARE)
“S73” (ACCESSORIES)
“S84” (PERIPHERALS)
Bookmarks