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
Hi Maurizio
See if this is what you wanted. You will need to modify it to suit your requirements.
Sunny
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
Hi Maruizio
I don't think I understand what you want and Google Translate isn't helping much either 🙂 Post a file with what you expect and hopefully in English and then maybe other members can understand and offer some suggestions.
Sunny
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/0fp67ap88zb7cy40kexby1mk8d0beulw
Hi Maruizio
Since you already have a working copy of the game, why do you want to create another one?
Sunny
Try this.
I am not familiar with the terminologies of tombola or bingo as I don't play them. So if any of them is incorrect please change it.
Sunny
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
