0 Members and 1 Guest are viewing this topic.

*

Gitano

  • 50+ posts Member
  • **
  • 98
  • Roulette Forum .cc | Member
  • Rated: +4
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!

 

*

cristal2000

  • 50+ posts Member
  • **
  • 60
  • Rated: +3
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

*

Gitano

  • 50+ posts Member
  • **
  • 98
  • Roulette Forum .cc | Member
  • Rated: +4


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:   

*

cristal2000

  • 50+ posts Member
  • **
  • 60
  • Rated: +3
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:




*

Gitano

  • 50+ posts Member
  • **
  • 98
  • Roulette Forum .cc | Member
  • Rated: +4
Thank You Cristal2000!! I will download it now!!
Meanwhile I was studying and I have learnt a few VB! It's amazing!

luckyfella

  • 100+ posts Member
  • ***
  • 146
  • Roulette Forum .cc | Member
  • Rated: +7
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
I don't believe systems play wins itlr.....favourite quote

*

Gitano

  • 50+ posts Member
  • **
  • 98
  • Roulette Forum .cc | Member
  • Rated: +4
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!

 

Popular pages: