June 26, 2016
Hello and good day to all of a Warm Happy New Year 2017 I have it
My name is maurizio and my problem is this:
Years ago I had created with VB6.0 the Tombola game very Cute as me back
the voices of the various outputs such as (Ambo); (Terno); etc...!
And I must say that still works wonderfully well.
Now, however; And here's the catch: And I would like to transform the whole leveraging them where both
can, in VBA, but without using the classic Userform, but well only the Excel Spreadsheet
I've tried to change my all to try to adapt to this but without lingiaggio
To do it ever.
For here there is any of you who feels awkward to give me a hand in transforming all in
so that it can also work around the VBA Thanks
(P.S) I offer my test project that gives me no error, but does not even appear nothing
what I would like.
So sorry for the mess that I've done in the Enter the Test File, But what a little more Reale and the Second File one marked with the number 1
Thank you
VIP
Trusted Members
June 25, 2016
June 26, 2016
SunnyKow Hello and Thank you for giving me your project and Bello, however, in my I also inserted the comment when he went out of the both rather than the internal etc ...!
While in your indicates only (Number Extract); the (Correspondent Name) you have Inserted in sheet 3; and the Final Commentary of 90 numbers.
Now my demand is this: It could be enough if the Abbinassi in a Form I proseguissi with your list to create a function that determines the Out outputs (Ambi; Terni; quaternions) etc ..!
And if so where better to insert his call to this function so as not to jeopardize your whole job.
I await your instructions, Thanks again for everything and Happy New Year
VIP
Trusted Members
June 25, 2016
June 26, 2016
Hello SunnyKow What I intend to say: And I would like to be able to Have a Tombola What I Highlight with colors Other than early, when on the same course has left the "Ambi; Terni; quaternions or fives".
I explain better: As you certainly will know, the Tombola and play format (6 sections) with (15) numbers each.
Now if by Example We take aim at the First Chamber is composed of numbers that must be (Dall '1-5) Then Riga Sotto (Dall' 11-15) and again (Dall '21-25), and so for the other Sections that make up the game plan.
You'll notice that the same: Self in Front Row is extracted for example: the number (1) and then the (3) or the number (5) (you'd have a Minimum Cash Prize) as you'd made a Ambo.
Now Staying on this same line: Self subsequent extraction Atro came out a number between (2; 3; 4; 5) You always Realizzaresti Cash a further fee stipulated at the beginning of the game in regard with Two Numbers You'd Done ( The both); You'd have the numbers with three Done (Terno), And so on until the Coming of (Cinquina) that are precisely five numbers released in Billboard all Ninety Numbers.
Here for moral of the story you can Say What (from 1 to 5)
Before he can get out of the both; Then the Terno; Then The Quaterna;
But even with all the other numbers you can get the same thing Provided that on the Same Row of That Number Group of numbers .
More than not I would know how to Help you
(P.S) Watch SunnyKow
Maybe I understand how I can Help you better understand the whole.
You try to have a look at my project, which is always the Bingo Game, but to do that I used a chart; Nice to you but too elaborate for my taste.
Instead I would like to be able to make a surface with just the Excel spreadsheet as you've Done but with the addition of what I said before.
For here to better understand the whole look at my program and all backgrounds have a look at cell (J12)
So doing will see that corresponds to each Ambo two numbers on the same line of that Section, Ditto for the Terno and so on.
TrĂ other things tell me what you think Hello and thanks again for everything from A.Maurizio
Link To Download the Bingo Game Chart  : https://app.box.com/s/0fp67ap8.....mk8d0beulw
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
June 26, 2016
Hello SunnyKow I took a look at your project and self and true that I do not speak very well The Italian, for here my speeches always leave a bit to be desired as they are Spanish.
It's also true that your project and Beautiful was just what I wanted, You are truly a Great; For here I just have to say thanks for all the heart
For quriositĂ I liked my work on the Tombola leveraging Chart?
(P.S) You know even I've never played this game, however, seen that I'm taking all my old projects I had created using Visual Basic 6.0 and I would trasfoemare them what I can do; exploiting the VBA's all.
Many thanks dinuovo and Arrivederc next to A.Maurizio
1 Guest(s)