#1 Roulette Forum & Message Board | www.RouletteForum.cc

IT & Software => Coding for Roulette => Topic started by: Gitano on Oct 18, 08:34 PM 2018

Title: EXCEL Tableau Buttons
Post by: Gitano on Oct 18, 08:34 PM 2018
Hi All,
can someone help me to add buttons to the tableau in a way to simply fill the yellow column spins only ?
Others formulas are ok for me.finally .but with buttons I'm encountering difficulties. Should I use a macro?

THANK YOU!


Title: Re: EXCEL Tableau Buttons
Post by: Cristal2000 on Oct 19, 01:23 PM 2018
Quote from: Gitano on Oct 18, 08:34 PM 2018
Hi All,
can someone help me to add buttons to the tableau in a way to simply fill the yellow column spins only ?
Others formulas are ok for me.finally .but with buttons I'm encountering difficulties. Should I use a macro?

THANK YOU!



Hi, you need macros and buttons

If I have time this evening I'll put them
Title: Re: EXCEL Tableau Buttons
Post by: Gitano on Oct 19, 01:48 PM 2018
Quote from: cristal2000 on Oct 19, 01:23 PM 2018


Hi, you need macros and buttons

If I have time this evening I'll put them

I'm going crazy with Macros...because one can use coding VBA  or automatic Active XControl or recording macro..!?WTF excel :o :sad2:   
Title: Re: EXCEL Tableau Buttons
Post by: Cristal2000 on Oct 19, 06:29 PM 2018
Hi, I added the keyboard complete of:

number entry buttons
button to delete the first number
button to delete last number
button to delete all
button for random number
button to import a permanence from a .txt file

and separate button to remove sheet protection
(because each button remove and replace the sheet protection)

:thumbsup: :thumbsup: :thumbsup: :thumbsup: :thumbsup: :thumbsup: :thumbsup: :thumbsup: :thumbsup: :thumbsup: :thumbsup: :thumbsup:


(link:://s18.imagestime.com/out.php/i1170918_123.png) (link:://:.imagestime.com/imageshow.php/1170918_123.png.html)
Title: Re: EXCEL Tableau Buttons
Post by: Gitano on Oct 19, 07:42 PM 2018
Thank You Cristal2000!! I will download it now!!
Meanwhile I was studying and I have learnt a few VB! It's amazing!
Title: Re: EXCEL Tableau Buttons
Post by: luckyfella on Oct 19, 08:34 PM 2018
Quote from: Gitano on Oct 19, 07:42 PM 2018
Thank You Cristal2000!! I will download it now!!
Meanwhile I was studying and I have learnt a few VB! It's amazing!
Cristal2000 has given you the sample how to write macro
Take it from there
Title: Re: EXCEL Tableau Buttons
Post by: Gitano on Oct 19, 08:46 PM 2018
Oh Yes! for sure!
a Big Thank You to Cristal2000; it's lead to be more a challenge and study excel than study my system  :wink: :xd:
:thumbsup: :thumbsup:
Very grateful and the macro for files .txt is fantastic!