Placing a value into the active cell

[Michelle Hillard]

Hi guys,
I would like to place a command button on my worksheet which automatically
places a text value into the active cell. Any ideas greatly appreciated.


--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com

 

[Amit Shanker]

Option Explicit

Sub test()

ActiveCell.Value = "My value"

End Sub

You can attach above code to a command button.

Amit