Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel forms button "click"
Greetings! I have a spreadsheet that uses several forms buttons with a macro
assigned to each. When I first created this spreadsheet under an older version of Excel, clicking the button would produce a visual "in/out" movement of the button. Now I'm using Excel 2002 (SP3), and the visual movement doesn't appear unless you click *and hold* the mouse button for about two seconds. This spreadsheet is used by university students in my lab, so they would click the button several times, not realising that the macro had run (it executes a calculation and writes results to another sheet in the workbook). I solved that problem by adding a "beep" to the macro, but that means I have to install speakers on the computers (which have a tendency to grow legs and walk out of the lab) when we perform this experiment. Is there a time delay setting that adjusts the speed of the button's click motion? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel forms button "click"
Don't know any way to change the "click" behavior, but rather than the beep
as a cue you could perhaps use a different visual cue, such as changing the font on the button to bold while your code runs: Sheets("Sheet1").Shapes(1).OLEFormat.Object.Font.B old=True ' at the top of the code Sheets("Sheet1").Shapes(1).OLEFormat.Object.Font.B old=False ' at the end of the code -- - K Dales "Jeff" wrote: Greetings! I have a spreadsheet that uses several forms buttons with a macro assigned to each. When I first created this spreadsheet under an older version of Excel, clicking the button would produce a visual "in/out" movement of the button. Now I'm using Excel 2002 (SP3), and the visual movement doesn't appear unless you click *and hold* the mouse button for about two seconds. This spreadsheet is used by university students in my lab, so they would click the button several times, not realising that the macro had run (it executes a calculation and writes results to another sheet in the workbook). I solved that problem by adding a "beep" to the macro, but that means I have to install speakers on the computers (which have a tendency to grow legs and walk out of the lab) when we perform this experiment. Is there a time delay setting that adjusts the speed of the button's click motion? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Click on cell (or "button"), takes you to appropriate information | Excel Worksheet Functions | |||
how to stop program with loop by click "Cancel" button | Excel Programming | |||
commnd button - when i rt click, "assign macro" isnt an option... | Excel Programming | |||
Disable Close "X" button on User Forms | Excel Programming | |||
Disable Close "X" button on User Forms | Excel Programming |