0 Members and 1 Guest are viewing this topic.

*

Gitano

  • 100+ posts Member
  • ***
  • 112
  • Roulette Forum .cc | Member
  • Rated: +5
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
  • **
  • 63
  • Rated: +8
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

  • 100+ posts Member
  • ***
  • 112
  • Roulette Forum .cc | Member
  • Rated: +5


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
  • **
  • 63
  • Rated: +8
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

  • 100+ posts Member
  • ***
  • 112
  • Roulette Forum .cc | Member
  • Rated: +5
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
  • ***
  • 207
  • Roulette Forum .cc | Member
  • Rated: +14
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
IGNORE LIST - STEVE, CALEB

Left the forum - 2 Dec 2018

*

Gitano

  • 100+ posts Member
  • ***
  • 112
  • Roulette Forum .cc | Member
  • Rated: +5
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: