+ Reply to Thread
Results 1 to 3 of 3

Looking for any value in 4 different cells simultaneously

  1. #1
    Forum Contributor CobraLAD's Avatar
    Join Date
    07-23-2007
    Location
    Boksburg, South Africa
    MS-Off Ver
    Office 2019
    Posts
    346

    Looking for any value in 4 different cells simultaneously

    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)

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Perhaps something like this!
    Please Login or Register  to view this content.
    Not all forums are the same - seek and you shall find

  3. #3
    Forum Contributor CobraLAD's Avatar
    Join Date
    07-23-2007
    Location
    Boksburg, South Africa
    MS-Off Ver
    Office 2019
    Posts
    346
    Hi, Simon Lloyd

    Thanks it works 100%

    Used the 4 differents cells in the place of combobox1 & 2 before exit sub
    So now it check if the quote is empty or not

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1