Placing a value into the active cell

  • Thread starter Thread starter Michelle Hillard
  • Start date Start date
M

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
 
Option Explicit

Sub test()

ActiveCell.Value = "My value"

End Sub

You can attach above code to a command button.

Amit
 
Back
Top