Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
key Press on Forms Button
Ok This is slightly different. Here I am using forms
buttons, not commandbuttons. I have a forms button called "Button 1" A macro is assigned to it called macro "Macro1". The macro contains the following 2 lines of code: Range("A5").Select Selection.Copy I want to be able to determine when I click on this button if I was holding down the shift key or not. Now I have about 100 forms buttons like this on my worksheet and they all have the same 2 lines of code, just referencing different cells. What I am trying to get at is this... I want to be able to hold shift down when I click on each of these buttons and if the program detects I am holding shift, it run a different code. How do I do this? Thanx Todd Huttenstine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find&press button | New Users to Excel | |||
Is It Possible To Have... After A Button Press A Message Pops Up ? | Excel Worksheet Functions | |||
hiding forms button | Excel Discussion (Misc queries) | |||
Option Button and forms | Excel Programming | |||
Proteting against a button press | Excel Programming |