+ Reply to Thread
Results 1 to 3 of 3

Userform button to match numbers in database and colour

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    knottingley england
    MS-Off Ver
    Office 365 Excel
    Posts
    53

    Userform button to match numbers in database and colour

    We are raising money in our local pub to raise funds for our children's Christmas party. We have devised a way using the national loterry.Each participant chooses six numbers of there choice and are entered in to a database. As the numbers come out each week the numbers
    are crosed off until finally after several weeks someone attains all six numbers or possibly more than one.I would like to use some code so the numbers could be enterd into the data base each week and colour the numbers red using a command button,also when any body attains six numbers there name will appear in a listbox.I Have attached what i require but i am not yet good enough to write the code
    Thank you Troysie
    Attached Files Attached Files
    Last edited by troysie; 02-09-2010 at 12:30 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Userform button to match numbers in database and colour

    VBA is overkill for this. You can do it all with a few formulas and conditional formatting.
    Attached Files Attached Files
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-09-2010
    Location
    knottingley england
    MS-Off Ver
    Office 365 Excel
    Posts
    53

    Re: Userform button to match numbers in database and colour

    Thankyou that works fine. I would now like to have a textbox at the top of the page to display the winners names when they win.I have tried to code this without any luck.hep would be much appreciated.Please find worksheet attached
    tegards Troysie
    Attached Files Attached Files

+ 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