View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd huttenstine Todd huttenstine is offline
external usenet poster
 
Posts: 260
Default 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