Insert when selected?

ktjf

New Member
Joined
Apr 19, 2012
Messages
10
The concept seems so simple, but I can't find it anywhere! I just need a y to automatically show up in a cell when the cell is clicked on.
That is all. :)
Thanks in advance!
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Target = "y"
Application.EnableEvents = True
End Sub
 

ktjf

New Member
Joined
Apr 19, 2012
Messages
10
Thanks for the fast reply!
I'm probably just being thick, but Its not working... it may be because I didn't tell you which column it is in. The y entries will need to be made in column A.
 

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
Thanks for the fast reply!
I'm probably just being thick, but Its not working... it may be because I didn't tell you which column it is in. The y entries will need to be made in column A.


That's not why it isn't working - the code I posted should work in any cell. Did you paste into the module of the sheet you're using, rather than a standard module?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,263
Messages
5,595,166
Members
413,973
Latest member
leon1974mk

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top