 |
|
You are not logged in! F.A.Q Log in Register |
 |
|
 |
 Now online (1)belb ...and 373 guests Last 5 registered Oplandisks nothingstar N_loop yipe foxtrotromeo Browse members... |
 |
Members 8025Messages 2614116 Today 2 Topics 127542 |
|
|||||||||
| |||||||||
|
|
I am trying to figure out a way to create a button in excel that performs a function. Anybody have any ideas? |
||||||||
|
|
|||||||||
| |||||||||
|
|
To elaborate, I mean a kind of yes no toggle, or anything. it could be a useless function. |
||||||||
|
|
|||||||||
| |||||||||
|
|
Do you mean a buttun inside a worksheet cell? Or on one of the toolbars? There's probably some way you can use VBA to create a checkbox (button style) but whether you can get the button in a cell, I have no idea. I use VB6 at work but never bothered with VBA. |
||||||||
|
|
|||||||||
| |||||||||
|
|
Just go to View>>Toolbars>>Control Toolbox |
||||||||
|
|
|||||||||
| |||||||||
|
|
Yeah. Button in a cell. I have written a spreadsheet that you tell what scale you want, and it randomly generates you a string of 8 notes. In order to have it recalculate the random notes, you need to make a change to the spreadsheet, the least destructive option pressing delete on a random empty cell. But I want to give it a better UI than that. It kinda feels too ghetto. |
||||||||
|
|
|||||||||
| |||||||||
|
|
Wow... I had that up there, but I never really paid attention to it after I placed it in my toolbar (probly because I fell asleep a few minutes later). Thanks! |
||||||||
|
|
|||||||||
| |||||||||
|
|
Yeah, that works. Add a button, position it, tweak properties, edit the code behind. Simple. Didn't think it'd be too tricky. |
||||||||
|
|
|||||||||
|
Messageboard index
|
|||||||||
