View Single Post
  #4   Report Post  
Chip Pearson
 
Posts: n/a
Default Fill Color with Keyboard Function

Matt,

Ctrl+Y repeats the last action, so it will do the fill only if
that was the last function performed.




"Matt Cromer" wrote in
message
...
Chip -
FYI
I happended on to this as I was testing to see if CTRL + Y was
used for any
other function, as I was going to assign a macro to that
keyboard shortcut.
That happend to be exactly the shortcut I was looking for.

"Chip Pearson" wrote:

No, there is no such keyboard shortcut. And, as far as I know,
there is no programmatic way to determine what color is the
current pallet color.


"Matt Cromer" wrote in
message
...
Is there a Key Combination that will fill the selected cell
with the color
that is selected on the pallet...as opposed to having to
mouse
to the pallet
at the top of the workbook????

Thanks!
Matt