How to set active cell + date formatting

[PepperCrab]

Hi everyone,
I have two very simple questions that I need help with.

1) I added buttons to my excel worksheet. When I press the button, it calls a VBA routine. When the routine is called, I want to set the ActiveCell to the cell which contains the button. May I know how I can do this?

2) I read a cell containing a date field and pasted it into another cell. I don't know why the formatting isn't coming our right. My code is:

Range("H2").Offset(row_count, column_count).Value = Format(transaction_date, "dd mmm yy")

No matter what I set the format string to, the date always comes out like this: "5/25/2011" (for 25th May 2011). I want it to appear like this: "25-May-11"

Thanks!

[davesexcel]

Place this code in a "Forms" Button

Please Login or Register  to view this content.

There are possibly better ways to do this then working with buttons such as a worksheet event.

[PepperCrab]

Thanks very much!