Hey guys, I need some help on a simple task. It is about a roulette system. I want to enter the winning number (1-36) in A3 cell, and automatically populate A1 with "red" or "black", and A2 with "pair" or "impair", like
ActiveSheet.Cells(i, 1).Value = "red"
But I cannot handle the FOR and IF parts. Also, will the cells be populated as soon as I enter a number and hit "enter"?
I will appreciate any help, Thank You.
Hi, burkoff,
you could create a lookup table for that and use WorksheetFunction.VLookup to get the results.
If you want to do it in code IŽd go with a Select Case to get out which numbers should show which color. For Pair you could utilize WorksheetFunctio.IsEven.
Start with the Worksheet_Change-event right behind the sheet and limit that to just the cell where you want to enter:
Ciao,
Please Login or Register to view this content.
Holger
Last edited by HaHoBe; 10-16-2012 at 02:57 PM. Reason: Code amendment
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks